Hide columns that contain 0 value

[tonyadams]

Hi Everyone,
Need you support to solve my issue and reduce the manual work through VBA.

Block Blast

I have big sheet have more that 300 columns (all the cells contain formulas), some columns are have values and some have zero values (but it changeable next day),
I need the VBA to search if the column has zero value and take action to hide that column. and if possible to unhide them if they have values.
Thanks

You can use a VBA macro to hide columns in an Excel worksheet that contain only zero values and unhide them when they have non-zero values. The code loops through each column, checks for non-zero values, and hides or unhides accordingly. To implement, open the VBA editor, insert a new module, and paste the provided code, then run the macro.