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)