I am having troubles with dynamic arrays and need some help figuring out how to resize the array in certain situations.
I have a two-element array where it's first or second element may increase. For example, Array(X, Y).
Now if Y increases, I do a Redim Preserve Array(X, Y), and it works fine. However, if X increases, but Y does not, and then I do the Redim, I get a subscript out of range.
Any tips on how resize dynamic arrays in different ways? Thanks!