worksheets("sheet2").Range("A1:A10").Name = "MyName"

application.Goto Range("MyName"), True

might be what you want.

however, if I wanted to copy something I would do

Worksheets("Sheet1").Range("J11:J20").copy _
Destination:=Range("MyName")


Without doing any selecting.
--
Regards,
Tom Ogilvy

"Jasons" wrote in message
...

I tried to use VBA to copy a range of data then paste it into another
worksheet. The problem is that I create the target (to be copied) range
in INSERT---NAME---DEFINE, or a dynamic range. How can I use VBA to
possibly select the dynamic range?

Thanks a lot,

Jasons


--
Jasons
------------------------------------------------------------------------
Jasons's Profile:
http://www.excelforum.com/member.php...o&userid=16108
View this thread: http://www.excelforum.com/showthread...hreadid=313797