Access a worksheet level named range with Refers To like "=5".

When a named range has Refers To like "=5" I can't seem to access the value
(or anything about the range for that matter) via code. I assume this is
because it doesn't point to a range and thus isn't part of the range
collection.

Is there a way to get to the value of this named "range" via code?

Thanks,
Jeremy

answer = [test]
where test was defined as =5.

"Jeremy Gollehon" wrote:

> When a named range has Refers To like "=5" I can't seem to access the value
> (or anything about the range for that matter) via code. I assume this is
> because it doesn't point to a range and thus isn't part of the range
> collection.
>
> Is there a way to get to the value of this named "range" via code?
>
> Thanks,
> Jeremy
>
>
>

Perfect. Thanks Bob.

Bob Umlas, Excel MVP wrote:
> answer = [test]
> where test was defined as =5.
>
> "Jeremy Gollehon" wrote:
>
>> When a named range has Refers To like "=5" I can't seem to access
>> the value (or anything about the range for that matter) via code. I
>> assume this is because it doesn't point to a range and thus isn't
>> part of the range collection.
>>
>> Is there a way to get to the value of this named "range" via code?
>>
>> Thanks,
>> Jeremy