Variants and Concatenation

If a string and a number are concatenated the result is a string. To be sure your concatenation works regardless of the data type involved use the & operator. The & does not perform arithmetic on your numeric values. It simply concatenates them as if they were strings.

The IsEmpty function can be used to find out if a variant variable has been previously assigned. For details, see the topic "IsEmpty".