Finding the last populated cell in Excel is a very important function.
There are a bunch of different ways to do this but we will highlight two of them in this section. You can either set a variable to equal the maximum rows in an excel sheet or you can reference the command in the first statement of a for loop.
Maxrows = sheets(Currentsheet).usedrange.rows.count
For currentrow = sheets(currentsheet).usedrange.rows.count