inserting range value in call
 

This is driving me nuts. I don't program much anymore.... so I forgot
this simple one.
And, I can't find an example here... and I 'm looking all thru my old
files. So, this way will be faster.
Thanks
jeff

I need the code to insert range name (xxx) value into cell A1

inserting range value in call
 

Range("A1").Value = Range("MyRange").Value
--
Hope this helps.
If it does, please click the Yes button.
Thanks in advance for your feedback.
Gary Brown



" wrote:

This is driving me nuts. I don't program much anymore.... so I forgot
this simple one.
And, I can't find an example here... and I 'm looking all thru my old
files. So, this way will be faster.
Thanks
jeff

I need the code to insert range name (xxx) value into cell A1