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 :confused:

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 :confused:

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 :confused:

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 B3:D4
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. :)