Need Macro To Hide Columns Please

[jenanne13]

I have a spread sheet where I only enter data in some of the columns and others may not be used. How do I hide columns that have no values without having to go in and manually hide them? I am trying to avoid printing spreadsheets 30 pages long.

Thanks!

 

[texasalynn]

Welcome to MrExcel board...

a simple macro can be done - what are the columns?

 

[hubblenutt]

Same issue. I'd like to hide columns that have all 0's down the columns. range with the values in them would be j2:fc94. if j2:j94 are all <= 0 hide column j.