Getting the entry of a Named Range

[Brad E.]

I have a Named Range called VERSION, in which I update every time I make a
new version of the workbook. In my macro, I want to grab this value.

ThisWorkbook.Names("VERSION").Value returns "=UPDATES!$D$16".

How should I change that line to return the value which is Cell D16 on my
UPDATES tab?

 

[Mike H]

Brad,

To get the value use

MyVar = ThisWorkbook.Names("Version").RefersToRange
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.

 

[RonaldoOneNil]

ThisWorkbook.Names("VERSION").RefersToRange

 

[Roger Govier]

Hi Brad

try
evaluate(thisworkbook.names("VERSION").value)

 

[Brad E.]

Thanks, Roger. I like this better than the "RefersToRange" method. Evaluate
makes sense to me. Brad