Thread: don't want column width change after refresh
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Corey ....[_2_] Corey ....[_2_] is offline
external usenet poster
  
Posts: 45
Default 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


Reply With QuoteReply With Quote