IsEmpty

Return TRUE if the expression is a variable has been initialised, otherwise return FALSE.

Syntax
      IsEmpty(expression)

Key
   expression    A variable.

The IsEmpty() function may be used in VBA.

Examples

Dim intDemo as Integer, result
result = IsEmpty(intDemo)
 Returns True

“An optimist will tell you the glass is half-full; the pessimist, half-empty; and the engineer will tell you the glass is twice the size it needs to be”

Related:

IsNull - Is expression NULL? True/False
Nz - Detect a NULL value.


© Copyright SS64.com 1999-2014
Some rights reserved