From: Jef Gorbach on 13 Apr 2010 18:18
On Apr 2, 2:46 pm, FrankM <Fra...(a)discussions.microsoft.com> wrote:
> I have a current Macro performing a sort for me ...
> 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, _
> ... but now I need to insert another sort. Only 3 criteria are allowed. What
> I want to do is specify after the sort above that if column A is the letter d
> then the section will be sorted ascending by column I.
> I hope that makes sense. But Range for this new sort will be constantly
> changing it could be rows 229 through 234 or it could be rows 230 through 233
> or any other possible combination.
> I don't know if this makes any sense but if anyone has any ideas I would
> love to hear them.
How about instead of sorting column(a), filter it for those rows="d"
and copying the visible rows to another sheet then sorting that subset
by your three criteria??