How to get a variable range?

[luolovepi]

I want to get a range of cells from column A to D, and a seperate cell with column value J. The row number of these cells depends on the ROW Number I passed into this Sub.
How can I use the Range property to get the expected result?

I write the code like this, but it seems like it is wrong.

Range("A"&thisRow:"D"&thisRow,"J"&thisRow)

 

[VoG]

Try

Range("A" & thisRow & ":D" & thisRow & ",J" & thisRow)

 

[Michael M]

try

Range ("A" & thisRow & ":D" & thisRow & ",J" & thisRow)

 

[Michael M]

Hey, is there an echo in here Peter.....

 

[luolovepi]

Hi Michael,

Thanks a lot!!

Regards,
lolo^-^

try

Range ("A" & thisRow & ":D" & thisRow & ",J" & thisRow)

 

[luolovepi]

lol....

Hey, is there an echo in here Peter.....

 

[luolovepi]

Hi dear Peter,

Really thanks a lot!! I sent you a private message to you just now. No need to reply la!

Thank you ^-^

Regards,
lolo

Try

Range("A" & thisRow & ":D" & thisRow & ",J" & thisRow)

 

[VoG]

If I hadn't been reading your PM I would have been able to reply quicker.

 

[Michael M]

Ok, OK, that's rubbing it in .....LOL !!

 

[luolovepi]

lol..alright~~~
and pls help me check this as well. Don't know where is problem...
I need the cell F42, B42, C6, FthisRow, CthisRow, DthisRow, IthisRow~~~

Range("F42, B42, F" & thisRow& ", C" & thisRow& ", D" & thisRow& ", C6, I" & thisRow)

Thank you in advance!

If I hadn't been reading your PM I would have been able to reply quicker.