IsEmpty
Determines if a variant parameter has been initialised.
The required Expargument is a variant containing a numeric or
string expression. However, because IsEmpty is used to determine if individual
variables are initialised, the Expargument is most often a single variable
name.
IsEmpty returns
True if the variable is un-initialised, or is
explicitly set to Empty; otherwise, it returns
False. False is returned
if Expcontains more than one
variable.
Note:IsEmpty only returns meaningful information for
variants.
Syntax
IsEmpty(Exp)
Exp
A valid string, number or Variant containing a value recognizable as a string or number.
Related Functions
Returns a Boolean True or False.
Related Functions
IsDate | IsNull | IsNumeric | VarType
Example
Dim x ' Empty
x = 5 ' Not Empty - Long
x = Empty ' Empty
y = x ' Both Empty
MsgBox "x" & " IsEmpty: " & IsEmpty(x)