Hello all -
I am trying to COUNT the number of rows in a range of cells until I come to a blank line (the last two rows of my spreadsheet are a blank line and then a TOTALS line which I dont want to count). Is this possible?? For example start in A3 and count until you hit a blank line.
This is the code I havebeen working with:
Sub DelRows()
Dim iRowCountA As Integer, iRowCountB As Integer
iRowCountA = Sheets(1).Range("A3").CurrentRegion.Rows.Count
iRowCountB = Sheets(2).Range("A10").CurrentRegion.Rows.Count
debug.print iRowCountA
debug.print iRowCountAB
End Su
The A3 and A10 just seem to designate the range of cells to count and not the actual starting point???
Any help would be great!!
Bookmarks