Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Select first empty row in a column | Excel Discussion (Misc queries) | |||
select next empty row | New Users to Excel | |||
How to select cells with values only (not empty ones)? | Excel Discussion (Misc queries) | |||
How to select cells with values only (not empty ones)? | Excel Discussion (Misc queries) | |||
select next empty cell | Excel Discussion (Misc queries) |