none
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  https://msdn.microsoft.com/en-us/library/office/gg251448.aspx

    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