Array Size & Dimensions Best Practice

Hi,

Generally speaking, does anyone have any suggestions regarding best practice for VBA array size & dimensions?

In my case, I'm thinking what the best path would be, given an array w/5-6 dimensions, containing approximately 1500 elements in each dimension.

I can either load each separately into its own array or create a single array with multiple dimensions, since each series is related. I will later perform basic math on the arrays.

Are there any typical stumbling blocks that the group can think of which are avoidable using one route or the other?

Any pointers are appreciated.

Thanks =)

Hi Shg

Thanks for the response.

Maybe I'm visualizing it wrong, not a VB guy by background.

Effectively, it would have 5-6 columns w/variant data types (mostly doubles and dates).

There would be 5-6 data points within each interval of the time series, extending in a chronological manner to ~1500 intervals.

Would it be considered a 2D array or a 5-6D array? I'm not sure the correct way to express it, thus the question.

Thanks for your help =)

Cool thanks for your help. =)