how do I set the default look of a pivot table that was created with VBA?

[Pat1009]

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?

 

[beka213]

Set the columns, rows to the size you would like them to be, just by dragging them. Then right click a cell on the pivot table. Select pivot table options, tab layout & format, check the preserve cell formatting on update box.

Hope this is what you were after.