This simple 10 line code doesn't work if just the reference is changed..why?

**duugg** · 06-10-2009, 01:19 PM

Awhile back, I asked for a macro to delete the whole row if a duplicate customer number was found in column B. Sometimes, though, my column numbers change. So, logically thinking, I simply changed the criteria, but the macro ONLY seems to work if duplicate customer numbers are in column B only.

This code below won't work if the Customer Number is in column D instead of B even if the reference of B:B is changed to D:D, it doesn't carry the macro over...Why?

Please Login or Register  to view this content.

Thanks

**shg** · 06-10-2009, 01:53 PM

Maybe like this (untested).

Please Login or Register  to view this content.

**Leith Ross** · 06-10-2009, 01:54 PM

Hello duugg,

I am guessing you missed changing the Cells references in the code. They are looking at column 2 or "B". If you want to examine cells in column "D" then the column reference needs to be a 4.

Please Login or Register  to view this content.

**duugg** · 06-10-2009, 02:28 PM

Leith,

Worked like a charm. I just have to remember to make 7 changes to the criteria anytime I would like to change the column reference.

Thanks again