Thread: ByVal Target As Range Issue -Requires mouse click away from validation list to action

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

any ideas????