IsEmpty function usage in Excel

First, IsEmpty grammar

Returns a Boolean value that indicates whether the variable has been initialized.

Grammar

IsEmpty (expression)

The necessary expression parameter is a Variant that contains a numeric or string expression. However, because IsEmpty is used to determine whether an individual variable has been initialized, the expression parameter is usually a single variable name.

Description

IsEmpty returns TRUE if the variable is uninitialized or is explicitly set to Empty, otherwise it returns FALSE. If expression contains more than one variable, IsEmpty always returns FALSE. IsEmpty only returns information that is meaningful for a variant expression.

Second, IsEmpty usage

This example uses the IsEmpty function to check whether a variable has been initialized.

Dim MyVar, MyCheck

MyCheck = IsEmpty (MyVar) ' returns TRUE. MyVar = NULL ' assigns null.

MyCheck = IsEmpty (MyVar) ' returns FALSE. MyVar = Empty ' Fu to Empty.

MyCheck = IsEmpty (MyVar) ' returns TRUE.