Sandler
11-16-2020, 03:41 PM
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 http://www.vbaexpress.com/forum/image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
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 http://www.vbaexpress.com/forum/image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7