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