From: Jef Gorbach on
On Apr 2, 2:46 pm, FrankM <Fra...(a)> 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, _
>         DataOption3:=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??