F
FrankM
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.
(e-mail address removed)
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.
(e-mail address removed)