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

Status
Not open for further replies.
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>
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top