View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Brad E. Brad E. is offline
external usenet poster
 
Posts: 76
Default Getting the entry of a Named Range

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

"Roger Govier" wrote:
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?

.