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/
|