[JFischel]

Hey all,

I'm writing some stuff in VBA to parse a spread sheet and load the parsed data into an Oracle Database. I'm cheating a little because I know exactly how many rows are being filled in. However, in the future I was hoping that the parser could run dynamically. Does anyone know if there's a function like maxrows() or something like that in VBA that will return the number of rows that have data?

Thanks

Josh

[Ω]

Not an excel whiz but would

=if(A1="", 0, 1)

and then add up the results work?

[JFischel]

Actually, I was able to work it out...There's a function built into Excel. You have to use it something like this:

>ActiveSheet.UsedRange
>LastRow = Cells(Cells.Rows.Count, "A").End(xlUp).Row

Thanks,

Josh

[Ω]

Me know no VBA. Me use simple functions.

[insha]

To get the number of rows that are being used:
getRowCount = ActiveSheet.UsedRange.Rows.Count

To get the number of columns that are being used:
getColCount = ActiveSheet.UsedRange.Columns.Count