You can't autofit a column ignoring row1 unless you delete all the entries
in row1, do the autofit, then put the entries back.

--
Regards,
Tom Ogilvy

"Steve" wrote in message
...
Thank you
-----Original Message-----

try using auto_open


such as:


sub auto_open

sheet("my sheet).select
range("a1:a50").select
etc....

end sub


This will run everytime the workbook is opened.


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

.