Need a macro to delete rows based on multiple conditions

Hello!

I just recently moved into a new job at work and one of my first duties is creating macros. I am woefully inept at this so far and for the most part have been reverse engineering recorded macros to learn.

My problem I am looking at is that I have an array of six codes in COLUMN B that indicate reversals of payments. Once I see one of these codes in this column I need the macro to check the same row for a value in COLUMN C once it finds that value it needs to move up a row and check to see if the same value is in that row. If all three values are true it needs to delete both columns.

Please Login or Register  to view this content.

In this example it would delete rows 1,2,4,5 but leave row 3 intact.

*This is the code I am currently attempting to use.*

Please Login or Register  to view this content.

This is how I would run those tests, read it through and you'll see. The goal here is to delete all the rows at once at the end, so this should be much faster overall.

Please Login or Register  to view this content.

For that many, I'd switch to this syntax:

Please Login or Register  to view this content.

When it breaks, and you DEBUG, what is the value of Rw?

The value of RW should never be 1. The loop is running from the last row up to row 2 and stopping.

What is the value of LR? That should always be higher than 2. If it's not, change the line of code above the loop where the LR variable is getting determined, choose a column other than "A".

I got the ranges defined but deleting the rows doesn't work still.

This is the code I have:

Please Login or Register  to view this content.

Also, the value of LR is set as 5000, due to my table range.

Let's see this macro in a sample workbook not doing the right thing....

Try zipping the file you're trying to upload.

The presence of an Excel "Table" is gumming up the works. So, we test for that, remove the table if it's there, run the macro, delete the rows, then put the table back:

Please Login or Register  to view this content.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.