< Day Day Up > |
Using the Is Functions for Flawless ProcessingAll functions are prone to errors if you don't reference the right type of data. Most of these errors can be avoided by a simple check using one of VBA's many Is functions:
All the Is functions use the same simple form Isfunction(value) where value represents the actual value, variable, argument, or expression being checked. Each function returns a Boolean value. If the value meets the condition being checked for the function returns True. Each function returns a False value if the condition isn't met. For instance, if the variable varValue is Null, the following function returns True: IsNull(varValue) |
< Day Day Up > |