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)
Published June 2018