Delete a range of rows above blank cell

does anybody know the code that would delete a range of rows that lie directly above a blank row (or cell)

Hello d_rock90,

You need to know two things: the address of the blank row or cell, and the number of rows or cells to be deleted.

This example deletes the bottom 5 cells and rows on a worksheet. Column "A" is used to determine the last row on the active sheet.

Please Login or Register  to view this content.