Count rows - ExcelBanter

Posted to microsoft.public.excel.programming

Hugh[_2_]

external usenet poster

Posts: 3

Count rows

Hi there,

How to count data rows? I tried following sub. It did not
work.

Private Sub CountRows()
Dim iCount As Long
iCount = 1
While Sheet1.Range("B" & iCount).Value < " "
iCount = iCount + 1
Wend
End Sub

Thanks in advance for your help.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Count all rows in column with data, Except rows 1-5	Gregory Day	Excel Worksheet Functions	4	March 27th 08 02:58 PM
match week, count rows, sum rows?	earls	Excel Worksheet Functions	2	January 5th 07 02:34 AM
Count number of rows, where non relevant rows are hidden	Pieter	Excel Discussion (Misc queries)	2	November 8th 06 12:24 PM
Count rows and insert number to count them.	Mex	Excel Discussion (Misc queries)	6	August 23rd 06 02:29 AM
Why does rngDataSource.Rows.Count = 65536 when worksheet Rows=95?	[email protected]	Excel Discussion (Misc queries)	12	July 22nd 05 12:50 PM

All times are GMT +1. The time now is 02:48 PM.

Menu

About Us