Defining Variable 2D array?

[magicbob007]

Hello Guru's! I am having a bit of an issue defining a variable 2d array. After searching around for a while and reading others posts I am stumped. Basically, my code works fine if I define the size of the 2d array up front, but if I try to leave the dimensions of the array open from the beginning the code errors out.

Here is my code so far:

Please Login or Register  to view this content.

So as you can see right off the bat I define the dimensions of the array as 20 by 2, but is there a way to modify this so that the initial dimension of the array is left variable? I realize I can redim the array down the line in the code once I determine the final x value, but can it be done up front similar to a one dimension array? For instance I have this code previously used to build a 1d array of unique values:

Please Login or Register  to view this content.

how do I accomplish a similar redim of a 2d array with my code?

[FortySixAndTwo]

I don't see why you can't ReDim whenever or wherever you want. I can't really help you with the how-to part because I don't know how you would declare what the dimension should be at any point in your code but I know that you CAN ReDim any time.

[magicbob007]

So I have already tried something like this:

Please Login or Register  to view this content.

But I get an error that the array as already been dimensioned?

[magicbob007]

ok so now I found a post that states you can only redim the outer bound of the 2D array? Any one to confirm that for me?

[magicbob007]

here is the solution:

Please Login or Register  to view this content.

I had to flip the array, and then I was able to redim the outer dimension without a problem.