AnsweredAssumed Answered

A question of using Formula

Question asked by FedcLei on Oct 24, 2011
Latest reply on Oct 25, 2011 by WDrago
Hi there,
I am trying to create a serial of Gobal variables, the name is a combination of text and sequencial number. The text name is "SubZone", and the seq number is 1, 2, 3,.....

SubZone1, SubZone2, SubZone3... each of those variable are array variables so if I use a fomula to get the variable, I put SubZone1[1] to get the 1st variable out from the declare variable 1, SubZone1[2] will eventally be the 2nd variable from SubZone1. The SubZone2[1], SubZone[2]... will eventually be the 2nd SubZone area and contain other set of array.

I want to put a "For Range" loop, so I do not need to create those SubZone manually, and because sometimes, the SubZone area has 12 and sometimes it only have 5. Therefore, I do not want to do it manually.I cannot use in the formula "SubZone"+A+"["+B+"]" and other form of combination and I cannot get it. I know it is simple but I just cannot think of it.

If you understand my question and know how to solve it, please let me know. Many thanks  

Outcomes