VBA - how to select a big range with a variable?

[Safadinhu]

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

[Richard Buttrey]

Hi,

I'm guessing you want:

Please Login or Register  to view this content.

However consider whether you really need to use the .Select instruction. Selects and Activates are rarely needed and since there is a time overhead involved with these since VBA has to jump back to the Excel application, in a large loop like yours this will slow things down considerably.

For instance if you're copying the range just refer to the Range object directly and use the .Copy instead of .Select.

HTH

[snb]

Please Login or Register  to view this content.

a real big range would be

Please Login or Register  to view this content.