hide columns on condition:make a macro

[Harry May]

Dear all,

I want to make a macro to hide columns when the result in a certain row reads zero.

Example:
row 3 looks like this: 1, 2, 0, 3, 0, 4, 0, 5
Now I would like to hide columns when the result in row 3 read zero.
After running the macro the sheet should look like 1,2,3,4,5, without deleting the columns.

Please advise!

[MSP77079]

Please Login or Register  to view this content.