title: Is using variants in vba bad for performance?
body: <p>I guess the title is pretty straightforward, what impact does declaring variables as variants, instead of a specific datatype, has on performance in VBA? </p>
  
  <p>Maybe it's because I am not that experienced with programming, but intuitively it should decrease performance due to the computer having to check which datatype is assigned, and then changing the variant to the assigned datatype, instead of immediately assigning the value to it. I have not been able to find some literature on this.</p>