Counting Rows in 2007

[Ken Hudson]

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

 

[Otto Moehrbach]

That or:
CountRows = Range("A" & Rows.Count).End(xlUp).Row
HTH Otto