ISNULL(expression) |
Returns the value True or False depending if the expression contains no data (Boolean). |
| expression | The expression to test. |
| REMARKS |
| * The Null Value can only be used in conjunction with the Variant data type. * If "expression" is Null, then True is returned. * If "expression" contains more than one variable and any of these variables are Null, then True is returned. * You can use the ISARRAY function to return True or False depending if the value is an array. * You can use the ISDATE function to return True or False depending if the value is a date. * You can use the ISERROR function to return True or False depending if the value is an error. * You can use the ISNUMERIC function to return True or False depending if the value is a number. * For the Microsoft documentation refer to learn.microsoft.com |
Debug.Print IsNull(Null) '= True
Debug.Print IsNull("") '= False
© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited Top