View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Paul Smith[_3_] Paul Smith[_3_] is offline
external usenet poster
 
Posts: 26
Default Using a named range

Range("tk").select (or .sort)


"Richard Mogy" wrote in message
m...
I have created a range using

ActiveWorkbook.Names.Add Name:= _
"tk", RefersToR1C1:= _
"=R" & firstrow & "C4:R" & lastrow & "C7"

and now I would like to sort the data in "tk"

How do I select that range so that I can sort it?

Thanks in advance --

Rich Mogy