Referencing variable in a loop
I don't know why I can't figure this out. I have a lot of variables
already defined A1, A2, A3 etc etc.
I'm running a loop and would like to call the needed variable like this
For i= 1 to 100
LR = Lastrow + i
Range("A"& LR) = A & i - G & i
next
is this not possible or something?
|