| Excel Maxrows |
Excel Maxrows (get the last row in Excel)
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
If you have a specific question about this, please comment below or post in our forum.
|