Sort Key as range

[patsfan]

Is it possible to utilize a sort "Key" range address and identify the range elsewhere? My goal is to highlight the sort "Key2" cell from this sort code.

"Cells.Sort Key1:=Range("A1"), Order1:=xlAscending, Key2:=Range("F2") _

, Order2:=xlAscending, Header:=xlYes"

I am looking to highlight the "Key2" cell address ([F2]) with something like this..."Range("Key2").Interior.ColorIndex = 16"

Thanks

 

[Luke M]

You would need to first define that range to a variable. Something like:

[pre]

Dim KeyRange as Range
Set KeyRange = Range("F2")
Cells.Sort Key1:=Range("A1"), Order1:=xlAscending, Key2:=KeyRange _
, Order2:=xlAscending, Header:=xlYe
KeyRange.Interior.ColorIndex = 16

[/pre]
The Key2 within the Sort method is just the name of the argument, so you wouldn't be able to reference to it anywhere else within the code. Hope that makes sense.

 

[patsfan]

Excellent. Thanks Luke. I guess I should have thought that one through a bit more. I'll get it some day