Accessing Named Ranges

  • Thread starter Thread starter Michael Monteiro
  • Start date Start date
M

Michael Monteiro

Can I access a named range defined on sheet1 from sheet2?
I have a loop that iterates though Application.Names and I
can see the named range I am interested in. However, I
cannot access it via Range(Application.Names("foo")). I
get an exception when I do. Is this expected behavior? Any
way around this?
 
set rng = Workbooks(2).Names("foo").RefersToRange

would be one way.

Regards,
Tom Ogilvy
 
Back
Top