Hi

Please help.

I've created a Macro to select all the rows of a table as pivot items on a Pivot Table, then remove any "0" values, however it selects all the pivot items, but doesn't remove the "0".

This is the Macro:

Please Login or Register  to view this content.
Does anyone have any suggestions about how I can get this to work?