Help with code

With data in cells A1:A12, in the immediate window, I get:

? Range("A65536").End(xlUp).Row
12
? Cells(Rows.Count,"a").end(xlup).row
12
? Range("A" & Rows.Count).End(xlUp).Row
12
? Range("A:A").End(xlUp).Row
1

Why (in the last case) am I getting 1 ?
Thanks (in advance),

If you select column A and do End, then Up Arrow, I get A1.

--
Regards,
Tom Ogilvy

<[email protected]> wrote in message
news:[email protected]...
> With data in cells A1:A12, in the immediate window, I get:
>
> ? Range("A65536").End(xlUp).Row
> 12
> ? Cells(Rows.Count,"a").end(xlup).row
> 12
> ? Range("A" & Rows.Count).End(xlUp).Row
> 12
> ? Range("A:A").End(xlUp).Row
> 1
>
> Why (in the last case) am I getting 1 ?
> Thanks (in advance),
>
>

The .End(xlUp) starts "searching" from the uppermost cell of the range object
specified. The range object A:A includes A1 so .End(xlUp) starts with A1 and
goes up from there. Hence it returns row=1

"[email protected]" wrote:

> With data in cells A1:A12, in the immediate window, I get:
>
> ? Range("A65536").End(xlUp).Row
> 12
> ? Cells(Rows.Count,"a").end(xlup).row
> 12
> ? Range("A" & Rows.Count).End(xlUp).Row
> 12
> ? Range("A:A").End(xlUp).Row
> 1
>
> Why (in the last case) am I getting 1 ?
> Thanks (in advance),
>
>
>