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

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

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

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

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