Named Range / use of Indirect?

[jim may]

In cell A1 I have the text Testme

Testme is a Named Range
with RefersTo set to:
=Sheet1!$D$3:$D$5

In VBA - How do I

Range("A1").copy Range("D4").PasteSpecial xlPasteValues

And D4:D6 will show
123
456
789

This thing is beating me up -- Indirect is likely involved, but,,,
TIA

 

[Airwolf]

Does this float your boat?

Sub Macro1()
'
'
TestMe = Range("A1").Value
Range(TestMe).Select
Selection.Copy
Range("F3").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
End Sub

 

[jim may]

Thanks Yard;
The confusion I spread here in the last few minutes
DOESN'T Compare to the Confusion I've faced here
alone in the Past Hour.
Sorry, and again thanks for taking a shot at this!!
Jim

 

[Jon von der Heyden]

Hi Jim

You could call the range directly like this:

Range("Testme")

and A1 houses the text Testme

so... Range("A1").Value will return Testme

therefore

Range(Range("A1").Value)

will work

 

[jim may]

Yes Jon - Your Code "Caused the lights to COME BACK ON here"

Had lost sight that Range("A1").value would produce Testme
then using Range again (or wrapped around existing Range("A1").value)
produces Range("Testme").

Appreciate your input - have a great weekend with your fine looking child (boy/girl?)
Jim

 

[Jon von der Heyden]

Girl

 

[jim may]

thought she was in PINK,
I know you are proud of her