Thread: Getting the entry of a Named Range
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
RonaldoOneNil RonaldoOneNil is offline
external usenet poster
  
Posts: 117
Default Getting the entry of a Named Range
ThisWorkbook.Names("VERSION").RefersToRange

"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?
--
TIA, Brad E.
Reply With QuoteReply With Quote