select down to the LAST non empty row
 

hey all

hoping someone can help a newbie to VBA

i want to select a range of entire rows down to the *last* non-empt
entire row. There may exist a few empty rows, but i want to skip thes
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 empt
rows in between.

thank

--
Message posted from http://www.ExcelForum.com