Delete all empty rows

**a94andwi** · 09-28-2015, 02:40 PM

Hello

I have this code that should delete all rows that are empty in my sheet.
It seem to try to delete all rows that are empty which creates and infinite loop and the macro never stops.
When I select only within a certain range (row1-954) it works very well. Row 954 is the last row with values in.

How can I change this so it deletes only between row 1 and the last row where there is values?

/Anders

Please Login or Register  to view this content.

**gmr4evr1** · 09-28-2015, 03:57 PM

Something like this...

Please Login or Register  to view this content.

**Aardigspook** · 09-28-2015, 04:58 PM

Hi,

Try adding this to your code, before your 'we work backwards' comment

Please Login or Register  to view this content.

This will select the entire working range (like pressing Ctrl-Home then Ctrl-Shift-End).
I've just tried it with your code and this works, though a VBA guru can probably suggest a better way of doing it