issue with nesting loops

[mbydl2]

Hi everyone!

i'm very new to VBA and i'm having some issues with nested loop structures.

i'm trying to write down certain values for 30 individuals for 50 days in 2 years. let's suppose i write the following code:

Please Login or Register  to view this content.

the values are written only for the innermost loop (only for the final year and final day) and i'm not sure how to get around that. In addition, i would like the loops to calculate the value of plants(p,1) for each individual but for that value to be constant throughout the days in a year. For example if plants(p,1) = 27 for individual number 1, i would like the value of 27 to persist for days 1 to UBday (for individul number 1 only) but to be calculated again as soon as a new year starts. I have tried using a collection to do this and it worked fine but the issue is that i need to later perform some calulations within the array and splitting the collection stores the values as string. I am very new to VBA so I have no clue on how to go about this so any help would be greatly appreciated!

[Keebellah]

The thing is you need to accound to the last loop too

Please Login or Register  to view this content.

[mbydl2]

Hi Keebellah!
Unfortunately the code you provided results in the same issue even if I place the code just after the day loop instead of after the year loop. Like i mentioned before, I have previously tried to use a colllection

Please Login or Register  to view this content.

This code actually ended up doing EXACTLY what i wanted but i later encountered issues due to the values being stored as string rather than numeric values and also, i later need to vary the value of nplants which was also a little problematic in a collection so i guess my question is: can i achieve the outcome of this code without having to use a collection? if a collection is the only option, can i get around the issue of the values being string and the variable limits of the collection changing after the addition of each collection?

[Keebellah]

Set the Stings to Val( the result here )
You must however be sure that the content of the result is indeed numeric

[Keebellah]

Sample file?

[mbydl2]

I actually ended up figuring it out but thanks so much anyway!!!

[Keebellah]

Good of you to let us know.
Don't forget to mark the post SOLVED