Difference between String and Variant Data Type

String data type
A String can include letters, numbers, spaces, and punctuation. Usually the dollar sign ($) type-declaration character represents a string.

Variant data type
Variant data type contain  string as well as the special values Empty and Null.  The VarType function defines how the data in a Variant is treated.