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