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?