I think you have created a name, but not a named range. Therefore, you can't
use Range(...) to refer to it. Try instead
MsgBox ActiveWorkbook.Names("IntRate").Value
Hope this helps,
Hutch
"Al" wrote:
I want to pass a value from my macro to a users worksheet, and I can
accomplish that as in the first half of my test or in your response. My
question is simply that I want to learn why what I did in the second half of
my test doesn't return the value I assigned.
--
Al C
"Don Guillett" wrote:
Then, try to explain what you ARE trying to do
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Al" wrote in message
...
I'm trying not to name a cell at all, and I'm curious as to why it doesn't
work in my macro. It can certainly be done on a worksheet.
--
Al C
"Don Guillett" wrote:
IF??? you want to name cell a1 then