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?