Pasting to a name...

[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?

 

[Dave Peterson]

Maybe...

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

Someotherrange.copy
pt_1.pastespecial paste:=xlpastevalues

 

[jan]

David,

Perhaps this:

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

Jan