I want to select the following range:

Range("BW2:CF2").Select

However, I want to be able to change the 2 to a different number
programmatically using i as the variable.

I've tried

Range("BW"&i ":CF"&i).Select

and it just doesn't work. What am I doing wrong?

Thanks,
Barb Reinhardt