Template keeps requiring resizing/fitting after data imported

  • Thread starter Thread starter George Lewycky
  • Start date Start date
G

George Lewycky

I have a template to re-import text files and the column headings and
column sizes keeps adjusting for some of the columns.

Is there any way to keep the settings from the template the same once
the data is imported ?

Any ideas or suggestions ?

I'm using Excel 2003

TIA


George
 
Your might record your headings and column sizes in a macro. Either create a
macro button and call the result from there or call it from worksheet
change. The latter requires no effort to update. Depending how your
worksheet is used it may give an unacceptable performance hit.
 
Back
Top