How to set a range using Cells(i,"b") and Cells(i,"c") if I always want to select these two cells next to each other?

[makiwara]

Range(Cells(i,"b"):Cells(i,"c")).Select

Unfortunetely it's not correct. Could you help me to solve this?

 

[RoryA]

The syntax should be:

Range(Cells(i,"b"), Cells(i,"c")).Select

If they are always 2 adjacent cells, you can just use:

Cells(i,"b").Resize(, 2).Select

 

[makiwara]

Thank you for your fast reply! Great!!! ))