I have tried 2 options to autofit column width but receive the following error:
Run-time error '1004':
Application-defined or object-defined error
Thanks in advancePrivate Sub Workbook_Open() Application.ScreenUpdating = False Worksheets("Summary").Activate Columns("B:E").AutoFit Range("B:E").EntireColumn.AutoFit
Bookmarks