I am trying to define EndRow in an Excel recordset in some code I'm writing.
My definition of EndRow is currently:
iEndRow = Range("A:A").End(xlDown).Row
The excel recordset contains multiple blank rows (distributed through the dataset) and so iEndRow does not describe the last row containing data. It describes the last row of data before the first of the blank rows.
Does anybody know how I can define the EndRow of my dataset that contains blank rows.