VBA: selecting Range with a variable

[cazdealer]

Hi,

I using a variable "i" in a loop macro.

right now, somewhere in my code, I use this:


Worksheets("liste").Cells(i, 1).Select

for exemple, if i = 2, this select cell A2


How could I modified that code to select a range instead of a single cell?

I would like to select from column A to J...
for exemple, if i = 2, this would select A2:J2...

thanks

 

[repairman615]

Hello,

Try:
<font face=Courier New>Worksheets("liste").Range("A" & i & ":J" & i).Select</FONT>

 

[cazdealer]

thanks