Using a named range
 

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

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

Using a named range
 

Range("tk").Select

"Richard Mogy" wrote:

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