IsEmpty Function

Description

Returns a value indicating whether a variable has been initialized.

Syntax

IsEmpty(expression)

The expression named argument can be any numeric or string expression. However, because IsEmpty is used to determine if individual variables are initialized, the expression argument is most often a single variable name.

Remarks

IsEmpty returns True if the variable is Empty; otherwise, it returns False. False is always returned if expression contains more than one variable.

See Also

IsArray Function, IsDate Function, IsError Function, IsMissing Function, IsNull Function, IsNumeric Function, IsObject Function, TypeName Function, Variant Data Type, VarType Function.

Example

This example uses the IsEmpty function to determine whether or not a variable has been initialized.

MyCheck = IsEmpty(MyVar)    ' Returns True.
MyVar = Null    ' Assign Null.
MyCheck = IsEmpty(MyVar)    ' Returns False.
MyVar = Empty    ' Assign Empty.
MyCheck = IsEmpty(MyVar)    ' Returns True.

This example sorts the data in the first column on Sheet1 and then deletes rows that contain duplicate data.

Worksheets("Sheet1").Range("A1").Sort _
    key1:=Worksheets("Sheet1").Range("A1")
Set currentCell = Worksheets("Sheet1").Range("A1")
Do While Not IsEmpty(currentCell)
    Set nextCell = currentCell.Offset(1, 0)
    If nextCell.Value = currentCell.Value Then
        currentCell.EntireRow.Delete
    End If
    Set currentCell = nextCell
Loop