datatypes RRS feed

  • Question

  • what is a variant datatype? what the pros and cons of it use with vba code where we have to use?
    Thursday, August 6, 2015 3:13 AM

All replies

  • Hi,

    Variant is a special data type which can contain any data type according to your need. You can assume it as a liquid which can take shape according to your provided Jar.

    To understand it more please go through link

    It is my personal opinion  try to avoid if you know the data type because when you use variant the application itself determine the type of variable which is a overhead.

    I hope this answer might help you.

    Rajat Jaiswal

    Thursday, August 6, 2015 3:36 AM