Subtype Explanation
Empty Variant is not initialized. Value is either zero for numeric variables or a zero-length string ("") for string variables.
Null Variant intentionally contains no valid data.
Boolean Contains either True or False.
Byte Contains integer in the range zero to 255
Integer Contains integer in the range -32,768 to 32,767
Long Contains integer in the range -2,147,483,648 to 2,147,483,647
Single Contains a single-precision, floating-point number in the range -3.402823E38 to -1.401298E-45 for negative values; 1.401298E-45 to 3.402823E38 for positive values.
Double Contains a double-precision, floating-point number in the range -1.79769313486232E308 to -4.94065645841247E-324 for negative values; 4.94065645841247E-324 to 1.79769313486232E308 for positive values
Date (Time) Contains a number that represents a date between January 1, 100 to December 31, 9999
String Contains a variable-length string that can be up to about 2 billion characters in length
Object Contains an OLE Automation object.
Error contains an error number.