variant data type

[lezawang]

Hi
I am trying to under variant data type and here it says:
"The Variant data type is capable of holding any type of data except fixed-length strings and user defined types."
what does "fixed-length" mean here? I tried this code and it works fine

Sub testing()
    For i = 1 To 10
    j = "hello"
    Cells(i, 1) = j
    Next i
End Sub

is not "hello" fixed length? J here is variant because i did not define it, so the default is variant.

https://bettersolutions.com/vba/data-types/variant-data-type.htm

 

[Michael M]

No, it just happens to be, in this case 5 characters !
You could have made j="hellooo", it would still work

There is an explanation here on the Variant data type and it's inefficiencies !
It is generally avoided as a data type unless there is no option

https://powerspreadsheets.com/vba-data-types/#Variant-VBA-Data-Type