HomePrivacy PolicyFeedbackLink to usSite Map

MS Excel: IsNull Function (VBA only)


In Excel, the IsNull function returns TRUE if the expression is a null value. Otherwise, it returns FALSE.

The syntax for the IsNull function is:

IsNull( expression )

expression is a variant that contains a string or numeric value.


Applies To:

  • Excel 2007, Excel 2003, Excel XP, Excel 2000

For example:

IsNull(null) would return TRUE
IsNull("Tech on the Net") would return FALSE

VBA Code

The IsNull function can only be used in VBA code. For example:

Dim LValue As Boolean

LValue = IsNull("Tech on the Net")

In this example, the variable called LValue would contain FALSE as a value.