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.