Getting rid of zero or blank columns

[Sandler]

Hi Everyone,

I have VBA code that takes certain filters in a pivot table and creates separate workbooks from it.
In those newly created workbooks, I need to take all columns that contain a total of zero or blank and get rid of that column.
I need the code to start in cell C & last row of the pivot table to that same row & last column of the pivot table, and analyze those cells for zeros or blanks and get rid of those columns.

Please help

 

[Sandler]

Bump...

 

[Sandler]

Alright, marking as resolved and seeking help from VBA Express.

 

[smozgur]

Alright, marking as resolved and seeking help from VBA Express.

That would be great if you could share your own solution for future readers. Then it is perfectly fine to mark it as the solution.