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 can 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 - Test for a NULL expression.
Nz - Test for a NULL expression or Zero Length String.


 
Copyright © 1999-2024 SS64.com
Some rights reserved