Your code works correctly on my system. If I enter YES in C35 the Rows are
visible, If C35 is empty, the rows are not visible.

Same thing with C41. 4 Week Month, visible - Empty, not visible.

What were you expecting it to do?

" wrote:

HI,
Could somebody please explain why this macro will not hide/unhide rows
57:59? The macro fires correctly, runs through the If statements
correctly but does not hide/unhide the rows in the second range. The
first range works perfectly.

Private Sub Worksheet_Change(ByVal Target As Range)
On Error Resume Next
Select Case Target.Address
'First Range
Case Range("C35").Address
If Range("C35").Text = "YES" Then
Rows("36:38").Hidden = False
Else
Rows("36:38").Hidden = True
End If
'Second Range
Case Range("C41").Address
If Range("C41").Text = "4 Week Month" Then
Rows("57:59").Hidden = False
Else
Rows("57:59").Hidden = True
End If
Case Else
End Select
End Sub