select down to the LAST non empty row
 

Hi,dabith £º

You Can Try This Code With VBA to get the lastrow who is not empty:

lastrow=Range("a65536").End(XLup).row

*example for columns A

--

³ÂÏ£ÕÂ@Öйú

*ÇîÇÒ¶ÀÉÆÆäÉí**´ïÔò¼æ¼ÃÌìÏÂ*



"dabith " wrote in message
...
| hey all
|
| hoping someone can help a newbie to VBA
|
| i want to select a range of entire rows down to the *last* non-empty
| entire row. There may exist a few empty rows, but i want to skip these
| to get to the very last row with data in it (regardless of columns).
|
| I have looked at xlDown command but I dont know how to skip the empty
| rows in between.
|
| thanks
|
|
| ---
| Message posted from http://www.ExcelForum.com/
|