Macro to hide column based on cell value

[kingharvest]

Hi,

i've looked at a few threads that have solved other peoples questions about this, but i can't get any to work with mine, mainly because i'm a macro novice.

I have a sheet where i need columns C,E,G,I,K,M to hide if the data validation drop down in Cell B4 is NO.
If B4 says YES, i need those cells to stay visible.
B4 will be blank until someone chooses Yes or No, just to let you know in case that has any effect on the code i need.

Seems relatively simple - can anyone help?

Andy

[john55]

try this

Please Login or Register  to view this content.

[MaczaQ]

or a bit shorter

Please Login or Register  to view this content.