don't want column width change after refresh
 

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

don't want column width change after refresh
 

You could fix it with :
Columns("A:A").ColumnWidth = 12 ' Adjust to suit th column and width
"Daniel" wrote in message
...
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

don't want column width change after refresh
 

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

"Corey ...." wrote:

You could fix it with :
Columns("A:A").ColumnWidth = 12 ' Adjust to suit th column and width
"Daniel" wrote in message
...
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