Pasting to a name...

G

Gojavid

This is a simple problem or it's not even possible, but I have some
code like

pt_1=worksheets("Sheet1").range("a1")

and I need to be able to use code to paste to this location using the
name I gave it.

I tried,

pt_1.pastespecial

, but obviously it didn't work.

Any suggestions?
 
D

Dave Peterson

Maybe...

Dim Pt_1 as range
set pt_1 = worksheets("sheet1").range("a1")

Someotherrange.copy
pt_1.pastespecial paste:=xlpastevalues
 
Top