Goal: Hide rows based on value in Drop Down Box
Problem: The code works fine if i manually change the $D$10. If I make changes to the Drop Down Box the cell link updates, but the rows are not hidden.
Can anybody help?
Code:
"Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$D$10" Then
Rows(11 & ":" & 50).Hidden = True
If Target.Value = "1" Then Rows(11 & ":" & 20).Hidden = False
If Target.Value = "2" Then Rows(21 & ":" & 30).Hidden = False
If Target.Value = "3" Then Rows(31 & ":" & 40).Hidden = False
If Target.Value = "4" Then Rows(41 & ":" & 50).Hidden = False
If Target.Value = "0" Then Rows(11 & ":" & 50).Hidden = False
End If
End Sub"
Bookmarks