tag:blogger.com,1999:blog-77790746445433167882012-02-10T16:46:48.123-08:00Raphaël Désalbreshttp://www.blogger.com/profile/15177799947234671966noreply@blogger.comBlogger21100tag:blogger.com,1999:blog-7779074644543316788.post-59764553686512481562009-04-19T13:50:00.001-07:002009-04-19T13:50:58.148-07:00Hi All,<br /><br />When I began writing macros in Excel 5.0 I didn't know how to find the last cell row, given a column...And that's useful, suppose you have a user form, and that you want to put the content of that userform on a sheet.<br /><br />So here's the tip: you just have to declare a long variable (you need this because on Excel 2003/2007 you have more than 32768 rows on a sheet).<br /><br />You can write it like this:<br /><br />Dim lastRow as Long<br />LastRow=range("A65536").end(xlup).row<br /><br />And that's it, folks!!!<div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/7779074644543316788-5976455368651248156?l=ms-technologies-en.blogspot.com' alt='' /></div>Raphaël Désalbreshttp://www.blogger.com/profile/15177799947234671966noreply@blogger.com0tag:blogger.com,1999:blog-7779074644543316788.post-49400077335622335642009-04-19T13:49:00.000-07:002009-04-19T13:50:01.594-07:00Here is a sample of an Excel spreadsheet made by me some years ago...<br /><br />A simple accounting system, with the diary,T accounts and balance-sheet...<br /><br />Click below to download the file<br /><br /><iframe style="BORDER-BOTTOM: #dde5e9 1px solid; BORDER-LEFT: #dde5e9 1px solid; PADDING-BOTTOM: 0px; BACKGROUND-COLOR: #ffffff; MARGIN: 3px; PADDING-LEFT: 0px; WIDTH: 240px; PADDING-RIGHT: 0px; HEIGHT: 66px; BORDER-TOP: #dde5e9 1px solid; BORDER-RIGHT: #dde5e9 1px solid; PADDING-TOP: 0px" marginheight="0" src="http://cid-c80cb697c4b0eb01.skydrive.live.com/embedrowdetail.aspx/Public/Exceldev/Acsys-Serv.xls" frameborder="0" marginwidth="0" scrolling="no"></iframe><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/7779074644543316788-4940007733562233564?l=ms-technologies-en.blogspot.com' alt='' /></div>Raphaël Désalbreshttp://www.blogger.com/profile/15177799947234671966noreply@blogger.com0