Excel Maxrows Function: Find the Last Populated Cell

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