Hey Folks,
I have a selection change problem. I am trying to hide rows based on the selection from a drop down (named QtrSel sitting in cell "C2"). I have visited several sites and looked at several questions here to see if I can figure out what is going on but to no avail. The code follows:
Any ideas
Thank you
Dave
I have a selection change problem. I am trying to hide rows based on the selection from a drop down (named QtrSel sitting in cell "C2"). I have visited several sites and looked at several questions here to see if I can figure out what is going on but to no avail. The code follows:
Code:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address = "C2" Then
Select Case Target
Case "Q1"
Rows("6:18").Hidden = False
Rows("19:31").Hidden = True
Rows("32:45").Hidden = True
Rows("46:58").Hidden = True
Case "Q2"
Rows("6:18").Hidden = True
Rows("19:31").Hidden = False
Rows("32:45").Hidden = True
Rows("46:58").Hidden = True
Case "Q3"
Rows("6:18").Hidden = True
Rows("19:31").Hidden = True
Rows("32:45").Hidden = False
Rows("46:58").Hidden = True
Case "Q4"
Rows("6:18").Hidden = True
Rows("19:31").Hidden = True
Rows("32:45").Hidden = True
Rows("46:58").Hidden = False
End Select
End If
End Sub
Any ideas
Thank you
Dave