I want to build a dynamic multidimensional array. I will
then populate the array from the rows of a worksheet. The
problem is the only example I can find for declaring a
mulidimensional array is:

dim myArray(1 to 5, 1 to 10) as single

Where I am using the following variables for the upper
bounds of the array:
lngRowCount, lngColumnCount

When I try to declare the array I get an error:

dim myArray(1 to lngRowCount, 1 to lngColumnCout) as string
Compile Error: Constant expresssion required.

Any Help?

Thanks,
JohnV