In many of my old macros I used the following code to get a row count in a
worksheet:

CountRows = Range("A65536").End(xlUp).Row

With the changes in 2007 I assume that I should use the following, more
generic code now?

CountRows = Cells(Rows.Count, "A").End(xlUp).Row

--
Ken Hudson

That or:
CountRows = Range("A" & Rows.Count).End(xlUp).Row
HTH Otto
"Ken Hudson" <(E-Mail Removed)> wrote in message
news:57F7B096-8F2A-41CC-B8E8-(E-Mail Removed)...
> In many of my old macros I used the following code to get a row count in a
> worksheet:
>
> CountRows = Range("A65536").End(xlUp).Row
>
> With the changes in 2007 I assume that I should use the following, more
> generic code now?
>
> CountRows = Cells(Rows.Count, "A").End(xlUp).Row
>
> --
> Ken Hudson