Hi,

Well done and clearly that will work. However note that generally speaking, loops should only be used for relatively small ranges since there is a time overhead involved every time the VBE has to jump back to the Excel App, and vice versa. You'll find that with large ranges this can start to get time consuming. Always try and use standard Excel App. functionality since this will be quicker. In this case you could still have a macro, but instead of looping down a range just have it perform the Data Filter and delete rows functionality.

Regards