Excel VBA Functions

1. CVar VBA function – Description The CVar VBA function   returns a value with the Variant data type  . The Variant data type can store both numeric and text data. When using this function, remember that the Variant data type itself is the least efficient data type in VBA. 2. […]

1. CStr VBA function – Description The CStr VBA function   returns a value of the String data type  . The simplest form of the String data type with a variable number of characters takes up as many bytes in memory as there are characters in a given text string. We […]

1. CSng VBA Function – Description The CSng VBA function   returns a value with the Single data type  . It is a number between -3.402823e38 and 1.401298e45  . The Single data type is 4 bytes in memory. We usually use functions when we want our data to be more efficient. […]

1. CLngLng VBA function – Description The CLngLng VBA function   returns a value of the LongLong data type  . It is an integer ranging from -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807 . The LongLong data type is 8 bytes in memory. It is important that the LongLong data type itself, unlike the Long […]

1. CLng VBA function – Description The CLng VBA function   returns a value of the Long data type  . It is an integer in the range –2,147,483,648 to 2,147,486,647 . The Long data type is 4 bytes in memory. The function can also be used to convert a number stored […]

1. CInt VBA function – Description The CInt VBA function returns a value of the Integer data type . It is an integer in the range -32768 to 32767 . The Integer data type takes 2 bytes in memory and is therefore very efficient. This way, we can convert low-valued […]