Dynamic Array and ReDim question

Hello all. I need to dynamically populate a two dimensional array. The rows are unknown, but the number of columns is known to be 8. I know about the redim method, but is there a way that I can take the recordset.count and define my array using that? I know that in myArray(x,8) the 'x' has to be a number and I can't assign it using a variable.

In the statement ReDim Preserve SpecArray(x,8), is there any way to assign 'x'?

Any help would be GREATLY appreciated.

Parallon