Prev: IF for inverting true/false
Next: Formula to find text and count it within an entire workbook
From: FrankM on 5 Apr 2010 11:28
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.

frankmhere(a)yahoo.com


 | 
Pages: 1
Prev: IF for inverting true/false
Next: Formula to find text and count it within an entire workbook