Sorting Named Range
Thanks
"Dave Peterson" wrote in message
...
with worksheets("sheet99").range("NameOfRange")
.sort key1:=.columns(1), ...
end with
would be one way.
Andibevan wrote:
Hi,
How do I sort a named range? Do I have to use
Application.goto reference:="Name of Range"
Selection.sort key1:=Range("A1") ......
Or is there a shoreter version of it?
Thanks
Andi
--
Dave Peterson
|