Accessing Named Ranges

[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?

 

[Tom Ogilvy]

set rng = Workbooks(2).Names("foo").RefersToRange

would be one way.

Regards,
Tom Ogilvy