Macro To Delete Entire Row If Dublicate Is Found

**SilverFox** · 12-06-2012, 12:22 PM

I have a work sheet called (waste data) what i am after is a Macro that will delete an entire row if the data in A, B & G is dublicated anywhere on the entire sheet

Lets say

A1 = 5 B1 = Jim G1 = Na41

A21 = 5 B21 = Jim G21 = Na41

Row 21 will be deleted as the same data is repeated in Row1

The same data will be repeated more that once in A, B & G, in this case it will delete them

Thanks

**arlu1201** · 12-06-2012, 01:22 PM

Try this code

Please Login or Register  to view this content.

Copy the Excel VBA code
Select the workbook in which you want to store the Excel VBA code
Hold the Alt key, and press the F11 key, to open the Visual Basic Editor
Choose Insert | Module
Where the cursor is flashing, choose Edit | Paste

To run the Excel VBA code:
Choose Tools | Macro | Macros
Select a macro in the list, and click the Run button

**SilverFox** · 12-07-2012, 05:09 AM

Hi Arlu

I have tried your code but keep getting an error, I have inserted a sample sheet for you to look at if you don't mind? The last 2 entries on this sheet are dublicates and one should be deleted

Thanks for the help

**Trebor76** · 12-07-2012, 05:34 AM

Hi SilverFox,

See how this goes:

Please Login or Register  to view this content.

Regards,

Robert

**arlu1201** · 12-07-2012, 05:41 AM

What error do you get and which code line is highlighted?

**SilverFox** · 12-07-2012, 05:57 AM

Hi Trevor thanks very much for this it worked first time, Arlu thanks also, the error i was getting was syntax error, not sure why. Thanks again guys. Problem Solved