View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default Can Excel tell me how many rows are populated via a functions?

Josh,

ActiveSheet.UsedRange.Rows.Count

will return the number of rows used on the worksheet.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Josh" wrote in message
...
Hello All,

I wrote an application that takes a data set and uploads it to
an Oracle
database. I'm cheating a little right now by using a hard
coded number of
rows to parse and upload from a spread sheet to the database.

I'm wondering if there is a function that I can use in the VBA
code that
will give me the number of rows that are populated so I can
have my parser
run dynamically versus having to use the hard coded number of
rows.

Many thanks,

Josh