Happy (almost) Friday!
The way this sheet is set up, each cell in Range B7:B75 contains a formula that updates to display a "0, 1, or 2" depending on information entered elsewhere on the sheet. I'm trying to write the macro so that whenever a cell in range B7:B75 =0, that particular row will hide. I also need it to unhide when it no longer = 0. I need this to update in real time whenever those values change.
I already have a macro running on this sheet to hide columns in a similar manner (which works perfectly), but I can't figure out the hide/unhide rows part. Not sure if I should try to add it to my existing macro, or if I should create a second one to handle the rows... Here's the macro that works for the columns:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Range("B1").Value = 4 Then
Columns("H:N").EntireColumn.Hidden = True
Else
Columns("H:N").EntireColumn.Hidden = False
End If
End Sub
Any help on this would be greatly appreciated!
Thanks,
DT