Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
end of data in an excel spreadsheet
- Thread starter koz
- Start date
koz<br>
It depends on what is in the spreadsheet. If you know beforehand you can test for a few blank rows (the maximum you would expect in such a sheet) and then end it.<br>
<br>
A more correct way if you do not know the layout of the worksheet is to use the .currentregion and/or .usedrange properties of the worksheet as in activesheet.usedrange. <br>
PK <p>PK Odendaal<br><a href=mailto: pko@mweb.co.za> pko@mweb.co.za</a><br><a href= > </a><br>
It depends on what is in the spreadsheet. If you know beforehand you can test for a few blank rows (the maximum you would expect in such a sheet) and then end it.<br>
<br>
A more correct way if you do not know the layout of the worksheet is to use the .currentregion and/or .usedrange properties of the worksheet as in activesheet.usedrange. <br>
PK <p>PK Odendaal<br><a href=mailto: pko@mweb.co.za> pko@mweb.co.za</a><br><a href= > </a><br>
- Thread starter
- #4
- Status
