Solved: How to properly redimension an array

[jamescol]

Say I start out with any array of unknown size:

[vCode]
Option Base 1
Dim myArray() as Variant
[/Code]

During the procedure, I query a table for the number of rows it contains. Now I need to allocate enough space in the array to hold 1 element for each row. How do I properly accomplish this task?

Next, I hit another table, and need to allocate more space in the array for its rows, while maintaining the data the array already contains? How do I do that?

Thanks,
James