View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Andibevan[_4_] Andibevan[_4_] is offline
external usenet poster
 
Posts: 103
Default 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