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