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:
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?![]()
For i = 4 To 1 Step -1 Range(Cells(41 - i, 15), Cells(41 - i, 19)) = i° Next i
Thanks in advance
Regards
Bookmarks