< 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:
You learn about arrays in Chapter 7, "Working with Arrays," (p. 105). 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 > |