Use Excel ISREF Function to check whether a reference is valid or not. You can check for a reference and it will return TRUE if that reference is valid, else FALSE.
In the below example, fruit is a valid named range but when you have used double quotation marks, ISREF Function is unable to test that reference.
To learn more about Excel ISREF Function you can check Microsoft’s Help Section. And, if you have a unique idea to use it, I would love to hear from you.