Need number of rows

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

There is ROWS and ROW functions.

"alsameer" wrote:


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

you can check you excel properties

I got a lot of my begginer help on this site... cool

www.MDOTutorials.com


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

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

thanks David.
I got it. "ActiveSheet.UsedRange.Rows.Count"
ur links were really helpful.


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

Just to make sure that you are working with what you think you
will be working with -- if you start with an empty sheet so that the
lastrow count will not be messed up and populate cells B34
you will get the following results (nothing is in the first two rows):

ActiveSheet.UsedRange.Rows.Count is 2
Cells.SpecialCells(xlLastCell).Row is 4
ActiveSheet.UsedRange.Address is $B$3:$D$4
---
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
...

thanks David.
I got it. "ActiveSheet.UsedRange.Rows.Count"
ur [Your] links were really helpful.