don't want column width change after refresh

[Daniel]

Hi all
I wrote query so it retrieve data and load to excel. When I hit 'refresh'
the excel
column width changes. How can I have a fix column width? I did fromat the
column but not help.
Daniel

 

[Corey ....]

You could fix it with :
Columns("A:A").ColumnWidth = 12 ' Adjust to suit th column and width

 

[Daniel]

Thanks Corey
But how can I write this formula. Need help step by step.
Daniel