IsEmpty Function

Checks to see if a string expression evaluates to an empty string or Null.

IsEmpty (String)

Parameters

String  -  (Input, expression, Required)

A non-string will return False.

Return Value

Returns True if the string is empty or if Null is passed. If the string is not empty, False is returned.

Examples

IsEmpty (“”)	Returns True
IsEmpty (“abc”)	Returns False
IsEmpty (1)	Returns False
IsEmpty (Null)	Returns True
IsEmpty (Error)	Returns False

TIP:

Functions are specifically for use in the Macro Editor. Refer to Microsoft's official VB and JScript documentation for scripting equivalents.

See Also

Functions | UBound Function | IsArray function | IsDate function | IsEmpty function | IsError function | IsNull function | IsNumeric function | IsSpaces function | IsURL function

---

© 2004-2021 looksoftware. All rights reserved.