IsNull Function
SyntaxGroupIsNull(expr)
Variable InfoDescription
Return the True if expr is Null.
See Also
Parameters Description expr A variant expression to test for Null.
IsNull, TypeName, VarType
Sub Main Dim X As Variant Debug.Print IsEmpty(X) 'True Debug.Print IsNull(X) 'False X = 1 Debug.Print IsNull(X) 'False X = "1" Debug.Print IsNull(X) 'False X = Null Debug.Print IsNull(X) 'True X = X*2 Debug.Print IsNull(X) 'True End Sub