Hi, i was wondering if one of you could give me a hand with this.
It's probably a minor issue but i can't seem to find the answer on anyone elses post.
I've two Private Subs on a worksheet, they link to cells with validation lists.
Cell "C5" (Private Sub Worksheet_SelectionChange) ... hides columns
Cell "C6" Private Sub Worksheet_Change(ByVal Target As Range) ... hides rows
Codes attached,
The problem i have is that when i select text from the validation list to hide columns, i have to click away from the list on to another cell for it to action. I do not have this problem with hiding rows, when i select from this one it automatically hides the appropriate rows ...
Any ideas, would be very helpful .... Cheers
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$C$6" Then
Range("A1:A320").EntireRow.Hidden = False
If Target = "General Overview" Then
Range("A10:A57,A60:A275,A283:A316").EntireRow.Hidden = True
End If
End Sub
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Select Case Range("C5").Value
Case Is = "Total"
Columns("C:AO").EntireColumn.Hidden = False
Columns("K:X").EntireColumn.Hidden = True
End Select
End Sub
Bookmarks