Hiding rows based on cell value

[OliviaT]

Hi,

I have the following code but it's not working.

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$Z$31" Then
Rows("37:44").Hidden = True
If Target.Value < 1.2 Then Rows("37:44").Hidden = False
End If
End Sub

Could someone please tell me why it's not working? As I change the value in cell Z31, Row 37 to 44 does not hide or unhide. Thanks in advance.

 

[OliviaT]

Hi Domenic,

Thank you so much!!! Your revised code worked perfectly. Please excuse my late response. I have been out of the office and did not get a chance to work on my project until this week. Thank you to everyone for your time and effort in helping me. I really appreciate it!

 

[Domenic]

That's great. Thanks for giving us your feedback.

Cheers!