Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sort without Selecting
My current code for Sorting selects the sheet, sorts the data then
returns back to my Data Entry sheet. How can I have this perform this without the code selecting the sheet? I just want it to happen in the background without the sheets flashing back and forth while this happens. I did a search and found some suggestions but can't find one that works for my application. Thanks Jody ' SortcpModels Sheets("cpModels").Select Columns("A:B").Select Selection.Sort Key1:=Range("A2"), Order1:=xlAscending, Header:=xlGuess, _ OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _ DataOption1:=xlSortNormal Sheets("Data Entry").Select Range("B3").Select |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Selecting only specific rows for a Sort - additional bit of info.. | Excel Discussion (Misc queries) | |||
Selecting only specific rows for a Sort | Excel Discussion (Misc queries) | |||
Pls. reply Sort Data and copy to next coulmn when sort order chang | Excel Programming | |||
Selecting in groups within a sort | Excel Programming | |||
Can I sort without activating / selecting sheet? | Excel Programming |