I have been asked to display a count of the rows in each sheet of an Excel
file at the top of each sheet (so that the user does not have to scroll down
to see how many rows of data there are). I want to do this through code.

Is this the best way to get a count of the rows:
ActiveSheet.UsedRange.Rows.Count
And I probably need to subtract 1 for the row with headings.

I also need to know--is there a way to display the count of rows above row 1
(where the column headings are)? Is there a row zero?

Thank you for any help you can give me,
Judy