Hiding Columns Based on Value - Help is much appreciated!

[Tenaciousjeebs]

Hey All,

I'm having a bit of trouble writing a macro to hide columns if target cells are "0". I say a "bit of trouble" because I really have no idea what I'm doing when it comes to writing VBA, although I can normally code-sling my way out of problems. I started with a bit of code I had adapted to hide rows, and now want to hide columns, specifically I:Q wherever cells I74:Q74 are 0. Here is what I attempted:

Please Login or Register  to view this content.

I'm sure that there is some stuff in there that defies the most basic rules of VBA but I've never formally learned them, unfortunately. I've also attached a sample for additional clarification.

Thanks very much for any help!

Best,

Scott

[jaslake]

Hi Tenacious

Please wrap ANY Code you post in Code Tags...it's a Forum Requirement.

Having done so, try this

Please Login or Register  to view this content.

[Tenaciousjeebs]

Excellent! That worked perfectly. I'll make sure to use the code tags next time.

Best,

Scott

[jaslake]

Hi Scott

It's a minor point but please do this now in your initial Post

I'll make sure to use the code tags

You're welcome...glad I could help.

If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.