Hey there,
This code will delete duplicate rows (located at C3 and on) that match cell C2 but it also deletes all rows after the last duplicate that shouldn't be deleted....what is wrong with my code?
thanks for any insight..i've tried playing around with it but no luck
Please Login or Register to view this content.
Last edited by ds16; 08-07-2012 at 04:31 PM.
Try this
Please Login or Register to view this content.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
that saved the ones at the bottom but now it missed one in the middle
i attached a sample spreadsheet i am using to test it
the ones with "save" need to be saved and the ones with "delete" should be deleted
edit: more specifically the one in D5 isn't being deleted
Last edited by ds16; 08-07-2012 at 04:25 PM.
found the answer
here is my code
thanks for the help!Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks