I need to change the default look/design of a pivot table that was created in VBA.
After a refresh (re-run the module), the pivot table comes up, but the first column (A) is huge.
It is so wide I cant even see column B unless I scroll over.
Is there something I can change in the VBA code to default it to a reasonable size?
After a refresh (re-run the module), the pivot table comes up, but the first column (A) is huge.
It is so wide I cant even see column B unless I scroll over.
Is there something I can change in the VBA code to default it to a reasonable size?