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.

 

 

 
Sitemap | Privacy | Terms
Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation.
Copyright 2011 ExcelHelp.com All rights reserved
More Info (+)