Thread: Altered Column Width
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.newusers,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
Don Guillett Don Guillett is offline
external usenet poster
  
Posts: 10,124
Default Altered Column Width
Refresh with a macro that has one line to reset the column width

columns(5).columnwidth=12

--
Don Guillett
SalesAid Software

<JoJo wrote in message ...
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.






Reply With QuoteReply With Quote