Deleting rows by searching a specific word or empty cell.

Hello All,

I would like to delete the entire row I the 15th column will have an empty cell. I used this code but it stops when It reach another empty cells.

Please Login or Register  to view this content.

This one works for me (EndNumber is the total amount of rows you have):

Please Login or Register  to view this content.

Maybe:

Please Login or Register  to view this content.

Hello Bmouse it works same has mine. I have to run the Macros many times for it to clear all the cells in 15th column with empty cells.

Hello John. the last cell in the Oth column is empty and so it did not get deleted. so I thing the count is not right. sometimes even last 4 or 5 cells will have no value and need to be deleted. so the count need to be set properly it . the count can be associated with the Ath column and it may work.

Hello John. the last cell in the Oth column is empty and so it did not get deleted. so I thing the count is not right. sometimes even last 4 or 5 cells will have no value and need to be deleted. so the count need to be set properly it . the count can be associated with the Ath column and it may work.

Hello Bmouse it works same has mine. I have to run the Macros many times for it to clear all the cells in 15th column with empty cells.

Ok, try this, it starts running from the end, so it shouldn't overlap any cells.

Please Login or Register  to view this content.

Hello Erick,

Perhaps this option may work:-

Please Login or Register  to view this content.

Cheerio,
vcoolio.

Ok, try:

Please Login or Register  to view this content.

Same error:the last cell in the Oth column is empty and so it did not get deleted. so I thing the count is not right. sometimes even last 4 or 5 cells will have no value and need to be deleted. so the count need to be set properly it . the count can be associated with the Ath column and it may work.

Amazing works perfectly thanks

Nothing is Happening Bmouse, John's code works perfectly Thanks anyway

I reset it too the A Column. So therefore that's not the longest column. Try:

Please Login or Register  to view this content.

Originally Posted by erickmcburger

Amazing works perfectly thanks

You're welcome. Glad to help out and thanks for the feedback. Please mark this thread as SOLVED.