Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I want a macro to automaticly read used columns and then sort the range
with column 1 For example if i have data like this a b c d 1 gus italy 22 april 2 jim spain 34 may 3 david france 45 june i don't want to give the range for sort at vba by myself. I want code to automaticaly define the used range and then sort with the next code Selection.Sort Key1:=Range("B1"), Order1:=xlAscending, Header:=xlGuess, _ OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _ DataOption1:=xlSortNormal |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Automatic sort | Excel Discussion (Misc queries) | |||
Automatic Sort | Excel Discussion (Misc queries) | |||
Automatic League Sort | Excel Worksheet Functions | |||
Automatic Sort | Excel Discussion (Misc queries) | |||
automatic sort | Excel Worksheet Functions |