Hide columns if the cell in the last row = 0

[Tamarissa]

Tester File.xlsx

Hi there,

I'm looking for a macro that will hide any columns that = 0 in the grand total row. This is not a static row, it moves up and down all the time, and this is where I'm running into problems.

Thanks for any help you can give!

[coreytroy]

Something like attached?

[Tamarissa]

Tester File_2.xlsm

I tried your macro, and it worked great for this file... but when I added more rows to it, it didn't work out very well at all

[JOHN H. DAVIS]

Another:

Please Login or Register  to view this content.