Hi Rahcel,

Please clarify you want the differnce in the number of filled rows in
sheet 1 and sheet 2 right?
By filled rows we here mean that there is data in any cell in these
rows. right?

Regards
Ankur
www.xlmacros.com

On Dec 19, 3:15 pm, Rachel wrote:
, I have two worksheets open that are similar. What I need to know if there
is a formula which tells me if there is a difference in number of rows
between the first and second sheet.