| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with Auto Fit Sub on open
I have the follwoign code to Sort a column on a worksheet and resize to
autofit but I keep getting run time error 1004. Any Advice? Private Sub Workbook_Open() Worksheets("Inquiry").Range("A2:B100").Sort _ Key1:=Worksheets("Inquiry").Range("A2"), _ Key2:=Worksheets("Inquiry").Range("B100") Worksheets("Inquiry").Range("B2:B100").Rows.AutoFi t End Sub |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto Open problem | Excel Discussion (Misc queries) | |||
| open up an excel program with an auto open macro | Excel Programming | |||
| auto open, auto close | Excel Programming | |||
| still having problem with open currently open excel file | Excel Programming | |||
| Problem With Auto Open | Excel Programming | |||
Threaded Mode
