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

Please Login or Register  to view this content.

Please Login or Register  to view this content.

any ideas????