Conditional hidding row

txs for your quick reply

Actually, I use these macro:

Sub Worksheet_Change(ByVal Target As Range)

If Target.Address = "$M$15" Then
If Target.Value = OTHE Then
Rows [62:72].EntireRow.hidden = True
Else
Rows [62:72].EntireRow.hidden = False
End If
End If
End Sub

but it reports a PopUp with: Argument not Optional

And there, I'm stuck ;-(((

Well for me Rows [62:72] does not work. Rows("62:72") works for me. Other thing is that i am presuming that OTHE was a text and not a variable, so it needed to be enclosed in ". Based on the above two, the below code works for me

Sub Worksheet_Change(ByVal Target As Range)
   If Target.Address = "$M$15" _
   Then
      Rows("62:72").Hidden = (Target.Value = "OTHE")
   End If
End Sub

still same issue --> Argument not optional

really don't understand what happens ;-(

Could you post a sample book with some sample data and your code on some shared site AND post back the link to the file back here.. May be it has to do with how sheet is there or some thing else.