Test Empty

You can also test for whether a variable is empty in either of two ways:

If varTest = Empty Then
MsgBox "The variable is empty."
End If

OR:

If IsEmpty(varTest) Then
MsgBox "The variable is empty."
End If

The IsEmpty ( ) function returns a Variant value of the Boolean subtype with the value of True if the variable is empty, False if not.

First