Hi,

One way,

Alt +F11 to open vb editor. Right click 'This workbook' and insert module
and paste this in on the right.

Call with
=lastrow()
in a worksheet cell


Function lastrow()
lastrow = ActiveSheet.UsedRange.Rows.Count
End Function

Mike

"LQ" wrote:

I am new to Excel 2003 and would like to know how I can find the total number
of records / rows in a particular file without scrolling down until I see the
last row entered. Is there someplace that gives me a total?