Checks to see if any expression evaluates to the special Null value.
IsNull (Expression)
Expression - (Input, expression, Required)
Specifies the expression to be evaluated.
Returns True if the expression evaluates to Null, otherwise False.
Use this function to test for null conditions rather than comparing expressions to the Null constant, as any Null value within a logical comparison (e.g. var1 <> Null) evaluates to Null, rather than True or False.
|
IsNull (“”) |
Returns False |
|
IsNull (“abc”) |
Returns False |
|
IsNull (1) |
Returns False |
|
IsNull (Null) |
Returns True |
|
IsNull (Error) |
Returns False |
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.