Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
sort range
I'm sorry if this is a repost but I asked this question last week and now I
can not find the question. It was odd because the same day I had seen a response but I look today and nothing, not even the question. I am using the following code in a Macro to sort my spreadsheet ... Range("A1:U700").Sort Key1:=Range("A2"), Order1:=xlDescending, Key2:=Range _ ("J2"), Order2:=xlAscending, Key3:=Range("K2"), Order3:=xlAscending, _ Header:=xlGuess, OrderCustom:=1, MatchCase:=False, Orientation:= _ xlTopToBottom, DataOption1:=xlSortNormal, DataOption2:=xlSortNormal, _ DataOption3:=xlSortNormal I would now like to have an additional sort. If the value in cell A is "d" then I want to sort that range by column I. I hope that makes sense. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sort a Range | Excel Programming | |||
Sort Worksheet Range from another worksheet range, Excel 2000 & 2003 | Excel Programming | |||
Search range and sort another range | Excel Programming | |||
formula to sort a range so that it matches the exact rows of a column that is outside that range? | Excel Discussion (Misc queries) | |||
Sort range changes during sort | Excel Discussion (Misc queries) |