| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting a worksheet without making it active
How can I change my code below so the sort will perform without making
AAA-Supervisor the active shett? Sheets("AAA-Supervisor").Select range(Y2:Z24").Select Selection.Sort Key1:=range("y4"). Order1:=x;Ascending, Header:=xlGuese, _ OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom,_ DataOption1:=xlSortNormal |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| making a different sheet active | Excel Programming | |||
| Trouble making another worksheet active | Excel Programming | |||
| Selecting an Excel tab, Delete Worksheet command is not active | New Users to Excel | |||
| Making an open workbook active | Excel Programming | |||
| Summing a range without making it active | Excel Programming | |||
Threaded Mode
