Using Value in Cell to hide/unhide rows

Hi Rob,

Thanks for the solution. i didnt know so many options were available. by the way, I'm having a slight issue based on the codes that you have suggested when i applied to another worksheet. This other worksheet is named "NDE Report" and is reflected as "Sheet8(NDE Report)" on the VBE window panel. Also i have tweaked my original codes with yours to be used in this worksheet but it does not automate the hiding function.

Sub MPI_CHK_BOX()

If Range("O26").Value = X Then
Rows("27:59").EntireRow.Hidden = True
Else
Rows("27:59").EntireRow.Hidden = False
End If
End Sub

- the above code was put into the module2 code box( do i have to take note of the X? should i put it in ""? This made no difference to the macro when i mnaully click it)

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$0$26" Then
Call MPI_CHK_BOX
End If
End Sub

- This one was placed into the worksheet(Sheet8) code box