I want to hide row 10 if A10="0", and unhide if the value changes.
I have come up with the following, but I cant seem to figure out how to watch multiple rows.
This works the way I want it for one row.
I want rows A10-A159 watched.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Range("$A$10") = "0" Then
Range("$A$10").EntireRow.Hidden = True
Range("$A$10").EntireRow.Hidden = False