Removing Items from a Column A based on Same Values in Column B, while simutanously..

Hi, So I have 3 Columns in an Excel Spread Sheet
Column A contains a list of values
Column B contains a list of values that may or may not be present in Column A
Column C has equal number of values as column A and the values correspond to each other

Now I need to remove ALL values from Column A that are in Column B

Ex.
Column A has
A
B
C
D
E
F
G

Column B has
B
C

Column C has
1
2
3
4
5
6
7


the resultant is Column A
A
D
E
F
G

Column B
B
C

Column C
1
2
3
4
5
6
7


this is done through this macro:

Please Login or Register  to view this content.

Now what i want to do is have this macro simutanously delete values from Column C as well

This means Column C should be
1
4
5
6
7



Any help is appreciated, im new to this, using Excel 2003.

Please see forum rules about enclosing your code in tags so it displays properly. [ CODE ] your code here [ /CODE ]. Here's a tweak to your code:

Please Login or Register  to view this content.

try switching these two lines:

Please Login or Register  to view this content.

My guess is that after deleting rCell, Excel loses track of how to perform the offset.

I tested with this

Test 1:

Please Login or Register  to view this content.

As expected, works.

Test 2:

Please Login or Register  to view this content.

Does not work. Entry B should be removed. WHY?

In my real data set, even weirder things are happened, entries in column C are being added to column B some how.....

It may be useful to add stops to your code at strategic points, then watch as the code executes. Below, I've added stops at some crucial points. Click the restore window button and size your visual basic editing window so that you can watch the code as it executes.

Please Login or Register  to view this content.

See if this helps isolate what's happening.