how to count rows

[Seeking help]

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

[Piotr Lipski]

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

[Bob Phillips]

Activesheet.UsedRange.Rows.Count

perhaps?


--
HTH

Bob Phillips

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

"Seeking help" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>