Getting the entry of a Named Range
Hi Brad
try
evaluate(thisworkbook.names("VERSION").value)
--
Regards
Roger Govier
Brad E. wrote:
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?
|