I use the 
LastRow = Cells(Rows.Count, "A").End(xlUp).Row
Most every time I write code now.

LastRow is a variable name I have Dim above
Rows.Count is the maximum number of rows in this version of Excel - Way down at the bottom.
Cells ( Row, Column) specifies a range you want to start in.
"A" is the column you are wanting
.End(xlUp) is the same as pressing Ctrl-UpArrow to hit the next non blank above
.Row returns what row was found.

So in English this says
Go to the very last row in my worksheet at Column "A" and press Ctrl-Up and tell me what Row it stopped in. Let the variable LastRow equal to that number.

Read http://www.mvps.org/dmcritchie/excel/cells.htm
http://msdn.microsoft.com/en-us/libr...ffice.11).aspx
http://spreadsheetpage.com/index.php...e_size_ranges/ I like this site.