I need to initialise several arrays, each of about 100 doubles. I have tried to use the Array() function to do this. E.g:
Dim v As Variant
Dim i As Integer
v = Array(0.00000154414016, 0.00000313028629, 0.00000620856271, 0.00001118206384, 0.00001883176701, ... etc.
i = 0
Do While i <= UBound(v)
mdblCoefs_10_1(i) = CDbl(v(i))
i = i + 1
However, entering the v = Array(...) line (which can get very long so I use the continuation character, _) causes VB6 (SP3) to perform an invalid page fault.
Is there a limit to the number of characters on any one line? VB has warned me that there is a limit of the number of continuation characters (_) that can be used on one line - although I can't remember what it is.
Is there a limit on the number of elements that the Array() function can handle? - I never get a waring message.
Is there a limitation caused by using a Variant type?