don't want column width change after refresh

  • Thread starter Thread starter Daniel
  • Start date Start date
D

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