Never used VBA before, please help!!

[cfoges]

Hi,

This will be my first time using VBA and writing code. I am completely clueless so details are greatly appreciated.

What I am trying to do:
I've created a Pivot table report that automatically refreshes everytime it opens. On every refresh, the auto-format, in particular column width, changes. My goal is to write code to establish fixed column widths. Is this possible?

Thank you for your help,
Chris

 

[lenze]

Hi and welcome to the Board!!
Try recording a macro while re-formatting your table. Then you can do it a will!! You might even be able to automate it with the refresh.

lenze

 

[cfoges]

Hi Lenze,

Thanks for the reply, however I did not want to record a macro and then run it, I want my sheet to automatically set to specific user defined column widths.

Thanks