-
Yeah - sorry about that -Couldn't resist!
Can anyone tell me the max number of elements toy can fit into an array? I want to fit around 4700 lines from a text file into an array (one line of text per element ).
Is this possible?
Cheers 'n' beers
Skeen
-
I thing you can, i don't know the limits though!
-
I'm getting an error <subscript out of range>
Does that mean I'm trying to put too much into the array?
-
It mean that you put more than you declare.
What's your code,
Are you doiing
Dim myArray(4700) as String
-
Array's are zero based, unless you declare Option Base 1, then the array starts with one.
-
4700 is very manageable. Probably the previous post has it right. Delcare your array as Dim MyArray(1 To 4700) As String.
Cheers,
P.
-
Nice1
I've declared it o to 4700 and it started to work
Cheers lads - Top Form!
Skeen