From: FrankM on
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, _

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.