Excel2000: Reading Named Range value from VBA

  • Thread starter Thread starter Arvi Laanemets
  • Start date Start date
A

Arvi Laanemets

Hi

Is it possible at all, and when yes, then how? To be more specific, I want
to write an workbook Open event, where I need the current weeknumber string
in format "yyyy.ww". There is a named range/function CurrWeek defined in
workbook, which returns exactly the value I need, but how do I get it? I
checked with Watch window, and the expression:
ActiveWorkbook.Names("CurrWeek")
doesn't return "2004.28" today - instead it returns
"=INDEX(Weeks_Week,MATCH(VLOOKUP(TODAY(),Weeks_Start,1,1),Weeks_Start,0))"
i.e. the 'Refers To' part of name definition (Weeks_Week and Weeks_Start are
named ranges which do return ranges from a table). And the same with:
ActiveWorkbook.Names("CurrWeek").Value
 
Hi Arvi,

try either
[CurrWeek]

or
Application.evaluate("CurrWeek")


regards
Charles
______________________
Decision Models
The Excel Calculation Site.
www.DecisionModels.com
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Modifying a Defined Name's Contents 10
Save As and new workbook new name used in existing code 8
Excel2000: Searching a value in named range 4
Syntax problem fassing named range into function 1
Copying Range Names to another open workbook 4
Strip file extension from fiel name with multiple periods."file.9.69.txt" 2
Delete Named rnage and Add Named Range 5
Named Range maker code 9

Back
Top