IsEmpty Function

Syntax:

IsEmpty(variantvar)

Group:

Variable Info

Description:

Return the True if variantvar is Empty.

 

Parameter

Description

Name$

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