Concatenate array name

[crimsontrooper]

Hi,
I have four arrays named 1deg, 2 deg, 3 deg and 4deg.
I would like to populate the contents of these arrays into range with a single loop i the following manner:

Please Login or Register  to view this content.

However this returns only a string composed with the "i" value and word "deg". Is there a way to concatenate the array name, so that the output would be the array contentes not the "i"+"deg" string?

Thanks in advance
Regards

[nigelog]

Along these lines ??

Please Login or Register  to view this content.

just noticed does not work, will look at again

[Sintek]

Perhaps this Nigelog...

Please Login or Register  to view this content.

[crimsontrooper]

Hi,
Thanks for the fast reply.
I've check and neither of the proposed solutions work. Do you have any other ideas?

Regards

[nigelog]

Hi Sintek
I thought I had a solution until I changed the entries in deg4. Trying to call the array name using an i integer is not as easy as I Thought

Please Login or Register  to view this content.

[Fluff13]

How about

Please Login or Register  to view this content.

[nigelog]

Spot on Fluff
I was sure I tried the array of arrays but must have missed something. It wasnt my question but thanks, it was starting to annoy me

[Rick Rothstein]

Instead of using deg1, deg2, etc. we can use an array named deg and save VBA the trouble of having to create an array of arrays to work from...

Please Login or Register  to view this content.

[crimsontrooper]

Hi,
@Rick,Thank you, now it works.
By the way, is there a method where i would'nt have to write multiple arrays into a new array? In the meantime I will use the code provided by Rick.

Regards

[Rick Rothstein]

It depends... where did the data for your original arrays come from? In other words, in your original message you said "I have four arrays named 1deg, 2 deg, 3 deg and 4deg"... how did you create those original arrays (you never showed us the code where you did that)?

[crimsontrooper]

@Rick, The original macro is quite long, so here is a code snippet, which I use to generate an example array:

Please Login or Register  to view this content.

As you can see, nothing fancy, just straight forward assigning range to array.
This way I have four arrays containing the results of the LinEst function. Finally the contents of these arrays are plotted into choosen range.