selecting a range of cells

I am working in VBA and am still trying to select ranges.

This statement works to select all the rows that are used
in columns A to C
Set rng = Range("A1:C" & Cells(Rows.Count, "C").End
(xlUp).Row)
rng.Select

I am trying to select all the rows from 3 on down in
columns N and O. This does not work as it only gets
through row 32. What am I missing?

Set rng = Range("N3:O3" & Cells(Rows.Count, "O").End
(xlUp).Row)
rng.Select

Please go to an Excel VBA NG. This one is for Oulook.

--
Viele Grüße
Michael Bauer


"Grandma Barb" <barbs3506@aol.com> wrote in message
news:3bda01c51f98$4081ddf0$a401280a@phx.gbl...
> I am working in VBA and am still trying to select ranges.
>
> This statement works to select all the rows that are used
> in columns A to C
> Set rng = Range("A1:C" & Cells(Rows.Count, "C").End
> (xlUp).Row)
> rng.Select
>
> I am trying to select all the rows from 3 on down in
> columns N and O. This does not work as it only gets
> through row 32. What am I missing?
>
> Set rng = Range("N3:O3" & Cells(Rows.Count, "O").End
> (xlUp).Row)
> rng.Select
>
>

>-----Original Message-----
>Please go to an Excel VBA NG. This one is for Oulook.
>
>--
>Viele Grüße
>Michael Bauer
>
>
>"Grandma Barb" <barbs3506@aol.com> wrote in message
>news:3bda01c51f98$4081ddf0$a401280a@phx.gbl...
>> I am working in VBA and am still trying to select
ranges.
>>
>> This statement works to select all the rows that are
used
>> in columns A to C
>> Set rng = Range("A1:C" & Cells(Rows.Count, "C").End
>> (xlUp).Row)
>> rng.Select
>>
>> I am trying to select all the rows from 3 on down in
>> columns N and O. This does not work as it only gets
>> through row 32. What am I missing?
>>
>> Set rng = Range("N3:O3" & Cells(Rows.Count, "O").End
>> (xlUp).Row)
>> rng.Select
>>
>>
>
>.
>OK just tell me what and where is a VBA NG. --Grandma
Barb