ISEMPTY

ISEMPTY(expression)

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

expression

The expression to test (Variant).

REMARKS

* The value returned is True if the variable if explicitly set to Empty.
* The "expression" can be a numeric or string expression, but most often it is a single variable name.
* You can use the ISARRAY function to return True or False depending if the value is an array.
* You can use the ISDATE function to return True or False depending if the value is a date.
* You can use the ISERROR function to return True or False depending if the value is an error.
* You can use the ISMISSING function to return True or False depending if an optional argument has been passed in.
* You can use the ISNULL function to return True or False depending if the value contains no data.
* You can use the ISNUMERIC function to return True or False depending if the value is a number.
* You can use the ISOBJECT function to return True or False depending if the variable represents an object.
* 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