Variable name concatenate with array

What I have is the 8 assembly lines and 3 shifts each. I don't want to copy and paste code for each line so I was trying to concatenate the varible name with a loop. I have a table with line rates that I can pull from our server into excel but the list is all shifts all lines and there are some quirks in it's display that I have to programatically fill in.

So I want to concatenate rLine# as the line number and then the array value is the shift rate.

Please Login or Register  to view this content.

How do I get prdline to pass its value to the array and not the name prdline? I get a type mismatch because prdline isn't defined as an array (I assume) When I do a "print prdline" in the immediate window I get "rLine1" which is exactly what I want. The next loop would be rLine2... etc. rLine1(1) would be our line rate for shift one rLine1(2) is 2nd shift and rLine1(3) is the line rate for 3rd shift. Then go to rLine2(1)...etc

Thank you!