RANGE in VBA

[Jasons]

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

 

[Tom Ogilvy]

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.

 

[Guest]

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