Solved: How to properly redimension an array

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

Code:

---


Dim myArray() As Variant

---

Is fine to start, but you would be better off not using variant if you don't have to.

Lets say you determine that there are x elements needed then:

Code:

---

Redim myArray(1 To x)

---

Now, you want to add 10 to the upperbound, but keep the data from 1 to x.

Code:

---

Redim Preserve myArray(1 To x + 10)

---

Thanks Jacob - works great! I did dim the array as string. What I was trying before forced me to use variant.

You guys make this look too easy!

Cheers,
James

Glad to help.

Take Care

Word coders scare me! "Ooooo..."