Programming Reference Manual

IsEmpty

Syntax

IsEmpty(variantvar)

Description

Return the True if variantvar is Empty.

Parameter	Description
variantvar	A variant var is Empty if it has never been assigned a value

See Also

TypeName, VarType.

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