Use Variants in Methods and Properties
Use Variants in Methods and Properties
Use Variants for Array Data
A variant is a special data type that can contain any kind of data except fixed-length string data and user-defined types. A variant can also contain the special values Empty, Error, Nothing, and NULL. You can determine how the data in a variant is treated using the VarType or TypeName VBA function.
You can use the Variant data type in place of most any data type to work with data in a more flexible way.