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

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

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