Separate One Array Into Multiple Small Arrays

Hello,

I have one big array which contains about 8000 elements and that number will increase over time. What I want is to separate that array into many arrays of 500 elements each.

How can I do that?

Second, after I have done some calculations I will need to re-attach these arrays back into one array.

Thanks in advance for your help.

Cheers!

Hi

One way would be as follows. Declare your 16 sub arrays, then use a Select Case Statement with 16 cases which identify the 501, 1001, 1501 .. etc.. records, and the array name that corresponds and then call a second procedure which populates the individual arrays. Something like the following

Please Login or Register  to view this content.

Then if you want to recreate the original array, do something similar but in reverse. If you get stuck with that just post back.

HTH

Thanks Richard!