thanks v.much, but where in the code

--
GazM
-----------------------------------------------------------------------
GazMo's Profile: http://www.excelforum.com/member.php...fo&userid=1461
View this thread: http://www.excelforum.com/showthread.php?threadid=27239

hi,
there is already a line in the code that
says "columns.autofit".(which doesn't work)
I assumed this was the line you wanted replaced with
"cells.entrirecolumn.autofit". (which does work)
the line of code above can go anywhere after import but i
usually put commands like that at the end of the macro as
a "tidy up" move after all the real work has been done.
Regards
Frank

-----Original Message-----

thanks v.much, but where in the code ?


--
GazMo
----------------------------------------------------------
--------------
GazMo's Profile: http://www.excelforum.com/member.php?
action=getinfo&userid=14610
View this thread:
http://www.excelforum.com/showthread...hreadid=272396

.