Hi all,

could you provide me with some VBA coding that will count the tota
numbers of rows and return the value or displaying it when it is bein
run..thanks:

--
Seeking hel
-----------------------------------------------------------------------
Seeking help's Profile: http://www.excelforum.com/member.php...fo&userid=3565
View this thread: http://www.excelforum.com/showthread.php?threadid=55547

On Mon, 26 Jun 2006 02:16:01 -0500, Seeking help wrote:

Hi all,

could you provide me with some VBA coding that will count the total
numbers of rows and return the value or displaying it when it is being
run..thanks:)

For single worksheet:

Public Function GetRowCount()
GetRowCount = 65536
End Function

As an alternative you can try:

Public Function GetRowCount()
GetRowCount = Range("A65536").End(xlUp).Row
End Function

If you don't want to count header row:

Public Function GetRowCount()
GetRowCount = Range("A65536").End(xlUp).Row - 1
End Function

--
PL

Activesheet.UsedRange.Rows.Count

perhaps?


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Seeking help"
wrote in message
...

Hi all,

could you provide me with some VBA coding that will count the total
numbers of rows and return the value or displaying it when it is being
run..thanks:)


--
Seeking help
------------------------------------------------------------------------
Seeking help's Profile:
http://www.excelforum.com/member.php...o&userid=35658
View this thread: http://www.excelforum.com/showthread...hreadid=555475