Try something like this:

=ROWS(A1:C10)

In that case, the function returns 10.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Dan" wrote:

Is there a function that will return the number of rows between two cells of
unknown distance, similar to selecting the first cell and pressing
SHIFT+CRTL+DOWN KEY and the number of rows is displayed in the "Name Box" in
the upper left corner of the spread sheet?

Thanks

Dan