View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JeffMelton JeffMelton is offline
external usenet poster
 
Posts: 17
Default 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?