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

VB Code:
  1. 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