If Or statement to check cell text and delete entire row if text is found

**VBA FTW** · 08-08-2013, 11:28 AM

I'm having a little trouble getting this sorted. In column A I have a list of letters: A, B, D, M and N. I need to loop through each cell, and delete all rows that contain B, M, N, as well as blanks. Here's my code:

Please Login or Register  to view this content.

My problem here is this isn't deleting the rows that contain the letter N. If I run the macro, it deletes rows that contain B, M, and blanks, and then if I run it a second time, it WILL delete the rows containing the letter N. Any ideas on what's going on here? I've attached a workbook with the code contained in a module. Thanks

**patel45** · 08-08-2013, 11:37 AM

Please Login or Register  to view this content.

**VBA FTW** · 08-08-2013, 11:39 AM

Thanks, patel45! Any way I could talk you into explaining what's wrong with my approach?

**ragulduy** · 08-08-2013, 11:42 AM

When you delete a row it knackers up the placement in the loop and effectively skips a row.

It is not actually ignoring the N's, that's just how it appears...

stepping through the loop backwards fixing this as deleting a row doesn't alter the rows above it.

**tigeravatar** · 08-08-2013, 11:43 AM

Alternate version...

Please Login or Register  to view this content.

**VBA FTW** · 08-08-2013, 11:46 AM

Great, that makes a lot of sense, thanks everyone!

If Or statement to check cell text and delete entire row if text is found

LinkBack

Thread Tools

Rate This Thread

Display

If Or statement to check cell text and delete entire row if text is found

Re: If Or statement to check cell text and delete entire row if text is found

Re: If Or statement to check cell text and delete entire row if text is found

Re: If Or statement to check cell text and delete entire row if text is found

Re: If Or statement to check cell text and delete entire row if text is found

Re: If Or statement to check cell text and delete entire row if text is found

Thread Information

Users Browsing this Thread

Similar Threads

Check for values in a table and if found add value found in column to left to list

[SOLVED] Macro To Delete Entire Row If Dublicate Is Found

how can I check the value 1 cell against the values of entire row

How to delete values of a cell if it is found in another coloumn

Check if cell value is found in a seperate range of values

Bookmarks

Bookmarks

Posting Permissions