Another Downside of the Variant

Another downside of Variant variables is that you as a programmer must sometimes pay close attention to what the Variant subtype is at any given moment. This is because of something called implicit type coercion, which is what happens when a variant variable changes its subtype automatically. Implicit type coercion occurs when you assign a new value to a Variant variable that is different then the value currently stored within it. The Variant variable “coerces” the subtype into another subtype based on the type of data assigned to it.