Prev: Auto format sheet
Next: series objects; finding specific ones in the collection
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, _
>         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??
First  |  Prev  | 
Pages: 1 2 3 4
Prev: Auto format sheet
Next: series objects; finding specific ones in the collection