IsEmpty Function

Syntax

IsEmpty(expr)

Group

Variable Info

Description

Returns the True if expr is Empty.

Parameters

Parameters	Description
expr	A expression is Empty if it has never been assigned to a value.

Example

---

Sub Main
    Dim X As Variant
    Debug.Print IsEmpty(X) 'True
    X = 0
    Debug.Print IsEmpty(X) 'False
    X = Empty
    Debug.Print IsEmpty(X) 'True
End Sub

See also

TypeName, VarType