IsEmpty Function

Syntax:

IsEmpty(variantvar)

Group:

Variable Info

Description: Returns the True if variantvar is Empty.

Parameters:

Parameter

Description

Name$

A variant var is Empty if it has never been assigned 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.