+ Reply to Thread
Results 1 to 4 of 4

Deleting Duplicate Row code troubleshooting

  1. #1
    Registered User
    Join Date
    07-23-2012
    Location
    Dayton, Ohio
    MS-Off Ver
    Excel 2003
    Posts
    20

    Deleting Duplicate Row code troubleshooting

    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?

    Please Login or Register  to view this content.
    thanks for any insight..i've tried playing around with it but no luck
    Last edited by ds16; 08-07-2012 at 04:31 PM.

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,167

    Re: Deleting Duplicate Row code troubleshooting

    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]

  3. #3
    Registered User
    Join Date
    07-23-2012
    Location
    Dayton, Ohio
    MS-Off Ver
    Excel 2003
    Posts
    20

    Re: Deleting Duplicate Row code troubleshooting

    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
    Attached Files Attached Files
    Last edited by ds16; 08-07-2012 at 04:25 PM.

  4. #4
    Registered User
    Join Date
    07-23-2012
    Location
    Dayton, Ohio
    MS-Off Ver
    Excel 2003
    Posts
    20

    Re: Deleting Duplicate Row code troubleshooting

    found the answer

    here is my code

    Please Login or Register  to view this content.
    thanks for the help!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1