Simple first unused row problem

[ScabbyDog]

I want a macro to look at Column A starting at the first row and when it finds the first cell that is empty delete the row where is found and also delete all rows in the entire workbook below it.

It has to look at the first row and then the second row etc until it finds the blank. Doing it backwards (going up from the bottom) will not work with my data.

[alansidman]

Try this:

Please Login or Register  to view this content.

[ScabbyDog]

Thanks for the help. That code takes a long time to run as I have many thousands rows of data that it is looping through. Any better way?

[Leith Ross]

Hello ScabbyDog,

Hree is a non looping method to delete the rows.

Please Login or Register  to view this content.