Sorting Named Range
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 |
Sorting Named Range
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 |
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 |
All times are GMT +1. The time now is 07:29 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com