Redim giving error

[Blobby]

I am trying to create and resize on the fly a multi dimensional array and im getting an error with the line:

ReDim Preserve ResultsArray(Arrayindex, 4)

Arrayindex contains the number 1 at the time of the error and worked first time thru with Arrayindex set to 0.

I am declaring the array in the globals as Dim ResultsArray()
and then the code at the time im getting the error on is redimensioning as it finds rows. Any ideas anyone? thanx

[techgnome]

Search this board long enough and you'll find out that this is one of the biggest things that sticks on our craw. In VB, you can't ReDim the first element of an array... only the second. It sucks I know, that's the way it is.

Would it be possible to switch your elements?

[Blobby]

Techgnome.....brilliant answer....thanks a lot......i knew it but its late and im not thinking straight. Maybe i should start again when ive got a clear head....cheers chap

[Shaggy Hiker]

You can redim the first element, but not the way you want to. The problem is that you can't use Redim Preserve on the first element. However, you can simply Redim the first element. Unfortunately, that will delete all the data from the array. The solution, is to copy the data into a temporary array, redim the array, and copy the data back into the original array. This is slow and cumbersome, but can be split into a function, I would think.

[Blobby]

Yep.....its just another point to tell Microsoft that they have written a load of bo*****. Why cant they write stuff in a logical way????? You just dont think as colums first then rows,....we are all taught in a way like Excel looks......rows first param....then columns second....its a lot harder getting to grips with columns then rows.