What Is a Variant?

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.