Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 1 of 1
Thread: Dynamic Array and ReDim question
09-25-2008, 07:39 PM #1
- Join Date
- May 2005
- Thanked 0 Times in 0 Posts
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 statementCode:
ReDim Preserve SpecArray(x,8)
Any help would be GREATLY appreciated.