ISEMPTY(expression)

Returns the value True or False depending if the Variant variable has been initialised (Boolean).


expressionThe expression to test (Variant).

REMARKS
* The "expression" can be a numeric or string expression, but most often it is a single variable name.
* The value returned is True if the variable if explicitly set to Empty.
* For more information, refer to the Data Types > Empty page.
* For the Microsoft documentation refer to learn.microsoft.com

Debug.Print IsEmpty("a")     '= False  
Debug.Print IsEmpty(100) '= False
Debug.Print IsEmpty("") '= False
Debug.Print IsEmpty() '= False
Debug.Print IsEmpty(Nothing) '= False
Debug.Print IsEmpty(Null) '= False

© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited Top