DaveAtlanta
Board Regular
- Joined
- Nov 9, 2005
- Messages
- 100
I am trying to set a check box to hide rows that have a zero value formula. I was able to piece together this macro to hide, but can't seem to figure out how to unhide when the check box is unchecked.
If CheckBox15 = False Then
Dim i As Integer
With Range("r6")
For i = 1 To 54
If .Offset(i, 0) <> 0 Then
.Offset(i, 0).EntireRow.Hidden = False
Else
.Offset(i, 0).EntireRow.Hidden = True
End If
Next
End With
End If
I would appreciate any suggestions and advise.
Dave
in Atlanta
If CheckBox15 = False Then
Dim i As Integer
With Range("r6")
For i = 1 To 54
If .Offset(i, 0) <> 0 Then
.Offset(i, 0).EntireRow.Hidden = False
Else
.Offset(i, 0).EntireRow.Hidden = True
End If
Next
End With
End If
I would appreciate any suggestions and advise.
Dave
in Atlanta