| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
dynamic sort
Thanks guys, you ROCK! They both work.
" How do I create a dynamic variable to sort my data. I'm attempting to creat buttons to sort by last name, total_score, ID, location. Thought if there was a way to set a variable (my sort range), I could then sort it on any of those criteria. Hope that makes sense. its this first part after the word Range ( ??????) instead of "A2:O120" I want it to find the last row and create that Range as a variable Range("A2:O120").Sort Key1:=Range("E2"), Order1:=xlAscending, Header:= _ xlGuess, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _ DataOption1:=xlSortTextAsNumbers Sorry, new to this stuff.. Thanks in advance Jeff |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sort dynamic range on active cell | Excel Programming | |||
| Sort Dynamic Range | Excel Programming | |||
| dynamic sort macro across 3 linked sheets | Excel Discussion (Misc queries) | |||
| Dynamic Sort Macro | Excel Programming | |||
| Dynamic Sort | Excel Programming | |||
![Joe Schmoe[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
