Application.Goto Reference:="rangename"
Selection.copy
go.to.the.other.sheet
Selection.pastespecial xlall

-----Original 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?
action=getinfo&userid=16108
View this thread:
http://www.excelforum.com/showthread...hreadid=313797

.