IsEmpty Function

Syntax

IsEmpty(variantvar)

Group

Variable Info

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