When does Names.RefersToRange Property Fail?

[asha3010]

Greetings,

I have created a dynamic name range called "Test" that refers to

Please Login or Register  to view this content.

I refer to this range in my code using the syntax

Please Login or Register  to view this content.

This works fine except when "Test" does not refer to a range, ie all cells are blank. I would like to know if there is anything else that will cause the "RefersToRange" property to fail. If not, then I plan to use this code when an error occurs

Please Login or Register  to view this content.

Thanks a lot
Asha

N.B. Due to the monsoons, the internet connection is unstable so may not be able to respond promptly to any follow up questions.

[romperstomper]

No it should work unless it's not a valid range (which could also be caused by deleting cell G1.)

[shg]

Please Login or Register  to view this content.

[asha3010]

Thanks to all for your response.
Asha