I am testing reports for an application and doing the preliminary verification by getting the rowcount. I am using the rowcount method; however, the issue is that there are blank rows in the report and that is skewing the numbers. Is there a way to not count the blank rows or ways to count only the rows with content?
You'd have to get the row count then loop through the table looking for blank rows. Where your cell value = "" decrease the row count variable by 1 for each iteration. I don't know of a more dynamic way of eleminating blank rows.