Greetings,
I have created a dynamic name range called "Test" that refers to
I refer to this range in my code using the syntax![]()
=OFFSET(Test!$G$1,1,0,COUNTA(Test!$G:$G)-1,1)
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![]()
Names("Test").RefersToRange
Thanks a lot![]()
If Err.Number <> 0 Then MsgBox "The list contains no data" Exit Sub
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.
Bookmarks