The question is somewhat ambiguous.
The number or rows in a spreadsheet is dependent on your version
of Excel. What are you looking for and how do you want to use it.

Ctrl+End will take you to the lastcell location which is the intersection
of the last used row an the last used column, but it is more like a high
water mark than a correct location. Some more insight into this can
be found at http://www.mvps.org/dmcritchie/excel/lastcell.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"alsameer" wrote in message
...

Is there any function which can return the number of rows present in the
specified sheet.

I remember I have seen one function for this befor somewhere. But not
able to recollect

thanks


--
alsameer
------------------------------------------------------------------------
alsameer's Profile: http://www.excelforum.com/member.php...o&userid=24041
View this thread: http://www.excelforum.com/showthread...hreadid=400171