Greetings,

I need to select a range on excel based on an i variable in a "for" loop. But can't figure out how.

Example:

For i = 3 To 99999
Range("A" & i).Select
Next

But i want to do that in a Range(A1:J1) style.

I tried Range("A"&i&:&"J"&i) and a lot of combinations, but no one worked.

Thanks for any help