I need to hide different rows based on a cell value.
The target cell will always be the same, but there are eight different values in the drop down list in the cell.
I am using Worksheet Change in VBA but it is not working
Note: A user may select a value from the drop down list in the Target Cell, but may then change their mind and select another value.
I need only the rows hidden for the selection chosen in the drop down list.
All other rows should be shown.
Following is a sample of code I am trying to use
Code
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$L$22" Then
Rows("26:36").Hidden = (Target.Value = "NEW PHONE & MOBILE NUMBER")
Rows("24:32").Hidden = (Target.Value = "DATACARD FOR LAPTOP")
End If
End Sub
When selecting NEW PHONE & MOBILE NUMBER, rows 26:32 are hidden as expected, but if I then change the selection in the target cell to DATACARD FOR LAPTOP only rows 24:26 are hidden. Rows 27:32 are not hidden