Question: vba how to find last row?
Answer: Range. To find the last used row in a column, this technique starts at the last cell in the column and goes up (xlUp) until it finds the first non-blank cell. The Rows. Count statement returns a count of all the rows in the worksheet.