Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

counting rows

Status
Not open for further replies.
marc456

marc456

Programmer
Mar 14, 2002
2
GB
How do I find the number of rows on a sheet, some sheets will have 65K rows. Am I best counting from the bottom or is there short cut.

Marc
 
Sort by date Sort by votes
All sheets have 65536 rows, at least from XL 97 onwards.

ActiveSheet.Rows.Count will confirm this.

Is that what yo uare looking for ?

A.C.
 
Upvote 0 Downvote
I need to know how many used/filled rows there are. I'm compiling some fault trees.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

remeng
  • Locked
  • Question
Delete dynamic table rows without removing password protection
Replies
7
Views
255
remeng
remeng
davefish
  • Locked
  • Question
Looping through a word doc to delete rows
Replies
7
Views
195
macropod
macropod
MattGreer
  • Locked
  • Question
Excel - Copy Filtered Rows from a table to a new blank worksheet
Replies
7
Views
197
combo
combo
MattGreer
  • Locked
  • Question
VBA Code Deleting a Column instead of Rows...
Replies
6
Views
155
SkipVought
S
kskinne
  • Locked
  • Question
VBA to conditionally delete rows - need faster method
Replies
5
Views
81
SkipVought
S

Part and Inventory Search

Sponsor

Back
Top