hide columns based on validation cell

[pbahra]

i need some assistance i have a
validation cell in C1
with the values 1,2 & 3
what i need to happen is after selecting 1from the validation cell
I need columns E-H to be hidden
after selecting 2 I need columns G-H to be hidden
and after selecting 3 i do not need any cells to be hidden

any help would be appreciated

thank you

[DonkeyOte]

You can use a Worksheet Change event

Please Login or Register  to view this content.

to insert the above - right click on the tab of the sheet to which the code is to be applied - select View Code and paste above into resulting window

this is just one approach of many.