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/