IsEmpty
Returns a Boolean indicating whether a Variant has been initialized.
Syntax: IsEmpty( expression )
- expression
- required A Variant containing a numeric or string expression. Most often, expression is a single variable name, since IsEmpty only returns meaningful information for Variants.
IsEmpty returns True if the variable is uninitialized or has been explicitly set to Empty; otherwise, it returns False. False is always returned if expression contains more than one variable.
Example
This example uses IsEmpty to determine whether a variable has been initialized.
Dim MyVar As Variant
Dim MyCheck As Boolean
MyCheck = IsEmpty(MyVar) ' True — uninitialised.
MyVar = Null
MyCheck = IsEmpty(MyVar) ' False — Null is not Empty.
MyVar = Empty
MyCheck = IsEmpty(MyVar) ' True.