don't want column width change after refresh

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
 
C

Corey ....

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Format column widths from one table to a separate table on same page 1
Dealing with a Pivot Table (when I don't want to) 0
Table Preferred width is changed when pasting 1
VBA - (re-) Set a Table Style 2
Column widths in Excel 2013 16
Table Column Widths Fixing Size in Word 2010 4
Column Width 3
Unable to set the desired column width for a table with merged cells 0

Top