About Variants (ActiveX)

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 these functions

You can use the Variant data type in place of most any data type to work with data in a more flexible way.