Altered Column Width

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Folks:


In use one column of my spreadsheet to import a text file. Each day I run a
refresh on the data.
However, after refreshing this data, I notice that the width of the column
into which data is received gets altered.

* How can I prevent the width of the single column from being changed as
I import data from a text file ?



Thanks,
John.
 
Refresh with a macro that has one line to reset the column width

columns(5).columnwidth=12
 
Don Guillett said:
Refresh with a macro that has one line to reset the column width

columns(5).columnwidth=12
Click to expand...
....

Or store the column width in a variable first, import into the column,
then restore the saved column width.
 
Back
Top