TypeName limitation: How to distinguish Worksheet Variable from Workbook variable

Hi, I have a function to check if a rangename already exists and I want it to work for both workbook-level and worksheet-level range names

ideally I'd like to pass either workbook or worksheet as one parameter, and the other with the name as a string

however I do not see how can the function check if the parameter is a workbook or a worksheet

typename and vartype return exactly the same for both

any idea on how to solve elegantly?


otherwise I'll create two paramters and check which one is missing etc (or a functino to check if is workbook or else)

thank you!

Hi JosephP, this is the code

Please Login or Register  to view this content.

Hi joseph I just realized what you meant
variables not initialized -- do not refer to any object...

Typename is useless if variable not initialized, but that is no problem for me

thank you!