VBA and Macros for Microsoft Excel

[Shinano]

I have started to read this book from page 1. Yes, I am still a VBA beginner...

Anyway, my curiousity got caught by the comment under CAUTION on page 55.

If this code:

Cells(Row.Count,1).End(xlUp)

Can be combined with this code:

FinalRow = Range("A65536").End(xlUP).Row

To enable compatibility with older versions of Excel, which does not have that many rows, then how is this done?

Any explanation is appreciated.

T.i.a.

 

[VBA Noob]

Using this statement

Rows.Count

in excel 2007 it will count 1,048,576 rows and in other version 65536 rows

So use this to be dynamic in both versions

FinalRow = Cells(Rows.Count,1).End(xlUp).Row

and this when not working in 2007 or not exceeding 65536 rows

FinalRow = Range("A65536").End(xlUP).Row

VBA Noob

 

[Shinano]

Thanks a lot for the explanation. I appreciate it.