Hide columns based on specific cell value

[samcdavies]

Hi I've searched the forum but can't find a specific way of doing this. I'm a beginner when it comes to VBA so would appreciate the help here.

I have formula in cells C58:CJ58 - the result will either be zero or a number. I would like a code that, everytime that sheet is opened, will hide any column where the cell on row 58 is zero. Ideally I don't want this to affect other columns in the sheet, but if it does, I can sort that out.

Is this possible?

Thanks in advance!

[ragulduy]

Try this - it needs to go in the worksheet object in the visual basic editor.

Please Login or Register  to view this content.

[watersev]

hi samcdavies, different option

Please Login or Register  to view this content.

[samcdavies]

Thankyou both. I used the first one simply becaue it was first, but they both work.

Thanks again,
Sam