By the way, you'll want to store that macro in your personal.xls file.
*******************
~Anne Troy
www.OfficeArticles.com
www.MyExpertsOnline.com
"Senator" wrote in message
...
I am importing .cvs records into Excel that I will save as an .xls file.
There are about 25 columns of information and each column has data of a
different character length. However, all the column widths are the same,
"8.43". This presents a very laborious process of having to manually
adjust
all the column widths. Is there a way to have Excel automatically adjust
the
column widths to fit the longest string of characters in each of the
columns?
Thanks