Finding Last Row

**DCSwearingen** · 10-02-2007, 10:07 AM

I have seen several ways of identifying the last row in a spreadsheet designed as a data table.

The two most prevalent methods seem to be:

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

What are the strengths and weakness for these two methods?

**VBA Noob** · 10-02-2007, 10:26 AM

See if links help or confuse you some more

http://www.rondebruin.nl/last.htm

http://www.ozgrid.com/VBA/ExcelRanges.htm

http://www.beyondtechnology.com/geeks012.shtml

http://www.vbaexpress.com/kb/getarticle.php?kb_id=417

VBA Noob

**DCSwearingen** · 10-02-2007, 10:58 AM

The link to Ron de Bruin's page is a treasure. I haven't yet looked at the rest, but will be there shortly.

Something as simple as Option Explicit... I have been typing it in ever since I saw how it could help identify typos. But I found how to set to always have it declared...

Thank You!!