Try something like this, John:
http://www.officearticles.com/excel/...rk sheets.htm
************
Anne Troy
www.OfficeArticles.com

"John" wrote in message
...
trying to calculate total number of rows over several worksheets without
having to go into each sheet.

Thanks