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
|