Use Variants in Methods and Properties

Use Variants in Methods and Properties

Use Variants for Array Data

 

ActiveX and VBA Developer's Guide > ActiveX Automation Basics > Use Variants in Methods and Properties > 

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.