Assigning values to names in a for next loop

[GazzaLDN]

Hi,

I need a little help here understanding how to write the below loop to assign values to the names created in the loop without using brackets in these names.

From what i understand the following would create Freq(1), Trans(1), Delivery(1), Freq(2), Trans(2), Delivery(2)........

I want to create Freq1, Trans1, Delivery1, Freq2, Trans2, Delivery2........

Please Login or Register  to view this content.

[JBeaucaire]

I'm not sure why you wouldn't just create a single array with 3 fields per row, insert all values in the array all at once. This code shows how to instantly create an 3 column array of the 25 rows starting at the activecell, then an example of how easy it is to address a certain 'row' in the array, in this instance row 22:

Please Login or Register  to view this content.

[GazzaLDN]

I've not used arrays before, would be something to use if starting from scratch, but the names without brackets above are used in several places in the code I'm adapting , so would have a lot of work to do to use MyArr(xx, x) in their place.

Was really trying to understand why in the original code I can't seem to get the first part of the name and the value i without brackets. Perhaps its something simple I'm missing.

[Norie]

What you want to do isn't possible.

[JBeaucaire]

Then just dim your variant at the start big enough to hold all the variables you want. In this example I started with 25 rows, then showed an example of searching every used cell in column C for the value "M", and filled in a row of the array with the values of A:C whenever a row is found. Then at the end, the value of "i" is also the last row in the array with any data, useful for later.

Please Login or Register  to view this content.

[GazzaLDN]

Hi JBeaucaire & Norrie,

I guess what I should have asked is there a way to Concatenate a Variable name on the left hand side of the equals sign.

For my current problem, I had to bite the bullet and edit the existing code to use "( )" around the value of "i" but a task made easier using the find and replace functions.

[Norie]

No it isn't possible.

Is there a reason you don't want to use arrays?

[GazzaLDN]

No it isn't possible.

Is there a reason you don't want to use arrays?

Was trying to avoid having to change a lot of variable names to tidy up some existing code.