<doesn't return the value I assigned

You didn't assign a value. You tried to Insert a defined name, but didn't refer to a correct cell or range reference. You referred
to i instead, which is not a reference, but contains the value 0.05

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Al" wrote in message ...
|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
|
|
|
|