Hide columns based on value

[arip]

I'm new to macros, and can't figure this out:

If any of the cells in B2:B8 = "Sem" then all of columns H and I need to be show, but hidden for "Year"


Screenshot:
Excel.gif

[tigeravatar]

arip,

Try the following macro:

Please Login or Register  to view this content.

Hope this helps,
~tigeravatar