Try some thing more specific eg. :-
Workbooks("wb1.xls").Worksheets("Sheet1").Columns( "A:E").AutoFit

although Activesheet.Columns("A:E").AutoFit should work too


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/