Selecting Ranges

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

You are missing one "&"

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

Jim Thomlinson


"Barb Reinhardt" wrote:

> 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

Barb

close ... try:

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

or

Range(Cells(i, "BW"), Cells(i, "CF")).Select

Regards

Trevor


"Barb Reinhardt" <BarbReinhardt@discussions.microsoft.com> wrote in message
news:423A1148-C78E-48F8-A725-6AC04F30671D@microsoft.com...
>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

I looked and looked for that. Don't ask me why I missed it.

Thanks! I knew someone here would find it quickly.

"Jim Thomlinson" wrote:

> You are missing one "&"
>
> Range("BW" & i & ":CF" & i).Select
> --
> HTH...
>
> Jim Thomlinson
>
>
> "Barb Reinhardt" wrote:
>
> > 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