Accessing Named Ranges
 

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?

Accessing Named Ranges
 

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

would be one way.

Regards,
Tom Ogilvy

"Michael Monteiro" wrote in message
...
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?