Is there a way I can identify a range to be sorted without using th
scrollcolumn function.

I'm referring to the result of recording a macro selecting a range b
dragging you mouse.

My range = ("G11:CX298")

Thank

--
Message posted from http://www.ExcelForum.com

set rng = Worksheets("Sheet5").Range("G11:CX298")
rng.Sort Key1:=rng(1,6) ' sort on column L as an example

The sheet doesn't even need to be visible.

--
Regards,
Tom Ogilvy

"hotherps " wrote in message
...
Is there a way I can identify a range to be sorted without using the
scrollcolumn function.

I'm referring to the result of recording a macro selecting a range by
dragging you mouse.

My range = ("G11:CX298")

Thanks


---
Message posted from http://www.ExcelForum.com/