Checks to see if any expression evaluates to the special Error value.
IsError (Expression)
Expression - (Input, expression, Required)
Specifies the expression to be evaluated.
Returns True if the expression evaluates to Error, otherwise False.
Use this function to test for error conditions rather than comparing expressions to the Error constant, as any Error value within a logical comparison (e.g. var1 <> Error) evaluates to Error, rather than True or False.
|
IsError (“”) |
Returns False |
|
IsError (1) |
Returns False |
|
IsError (1 / 0) |
Returns True |
|
IsError (Null) |
Returns False |
|
IsError (Error) |
Returns True |
Functions are specifically for use in the Macro Editor. Refer to Microsoft's official VB and JScript documentation for scripting equivalents.
UBound Function | IsArray function | IsDate function | IsEmpty function | IsError function | IsNull function | IsNumeric function | IsSpaces function | IsURL function
© 2004-2021 looksoftware. All rights reserved.