Another way
![]()
Private Sub Worksheet_Change(ByVal Target As Excel.Range) If Not Intersect(Target, Range("C35")) Is Nothing Then Rows(37).Hidden = (Target.Value = "No") End If End Sub
Another way
![]()
Private Sub Worksheet_Change(ByVal Target As Excel.Range) If Not Intersect(Target, Range("C35")) Is Nothing Then Rows(37).Hidden = (Target.Value = "No") End If End Sub
Thanks,
Mike
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks