try this one now then
DESCRIPTION.
Slight change from previous code. Now the macro looks at each cell in the row. If the cell is NOT empty (e.g. has a value) then the macro looks at the next row. For each EMPTY cell in the row, x is incremented. If x=total number of columns, then the row must be EMPTY, therefore Rows(r).Delete
NOTE 1
Macros dont update themselves, they have to be started manually. You can do this by adding an autoshape, then right click and ASSIGN MACRO.
NOTE 2
Deleting rows in this fashion may take some time, depending on number of empty rows, total number of rows etc. You may need to allow anywhere upto 5 minutes depending on the situation.
Bookmarks