title: Variant data type in VBA and positive uses of it
body: <p>There's lots of stuff on Google regarding the variant data type. Mostly, they say things like <code>"Avoid using it too much and here's why"</code> or <code>"It can hold any type of data"</code>, which things I understand. But I still don't fully understand when to use them. Can someone concisely explain and, more importantly, give examples of best uses of the variant data type (maybe even an example of passing a variant to a function as opposed to an explicitly declared variable)?</p>