RANGE in VBA
 

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

Thanks a lot,

Jasons :rolleyes

--
Jason
-----------------------------------------------------------------------
Jasons's Profile: http://www.excelforum.com/member.php...fo&userid=1610
View this thread: http://www.excelforum.com/showthread.php?threadid=31379

RANGE in VBA
 

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 :rolleyes:


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

RANGE in VBA
 

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 :rolleyes:


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

.