iterating and appending an array

[mbydl2]

Hi,

i'm currently working on a simulation of population dynamics of a butterfly species. I have put in place all the code necessary for the simuation within a single season within an array, however, I now want to iterate the array for the number of seasons in question and append the array for year two under the array for year one and so on. A further complication is that the size of the array for year 2 is dependent on the sum of the number of eggs laid per butterfly (written in array 1). i'm not sure how to go about the code for this. I can't yet attach any files in the thread so i realise it's a little difficult nevertheless i was wondering if anyone has any suggestions?

thanks in advance

[Richard Buttrey]

To attach a file choose the Go Advanced button at the bottom of the post window area, look underneath the window for Manage Attachments and take it from there.

To Add more data to a pre-existing array you'll need to redimension the array using the PRESERVE instruction. i.e.

ReDim Preserve MyArray(x) ' where x is the new upper bound

Not you can't use Redim an array if you originally Dimmed it as a static array, e.g. Dim MyArray(50)

However upload the woprkbook and I'm sure we can move this on.

[mbydl2]

oh okay! Thanks very much!
workbook attached

[mbydl2]

for the code i was using a simple flowchart that i'm attaching now if that's of any use