+ Reply to Thread
Results 1 to 4 of 4

Deleting an entire row using a removeduplicates function? A better way?

  1. #1
    Registered User
    Join Date
    12-27-2012
    Location
    Fort Wayne, Indiana
    MS-Off Ver
    Excel 2007
    Posts
    17

    Deleting an entire row using a removeduplicates function? A better way?

    Hello,

    First I'd like to say how great this forum is and the people that make it great.

    I am comparing columns A through T and trying to delete the ENTIRE ROW when some data is duplicated. The data after that is not duplicated, so I am having a lot of difficulty getting the macro to delete the ENTIRE ROW instead of just the duplicated cells. Below is one of the methods that I've tried.

    I've tried many. Obviously, this one is only deleting the duplicate data and not the ENTIRE ROW.

    Any help is appreciated!!!

    Please Login or Register  to view this content.

  2. #2
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,380

    Re: Deleting an entire row using a removeduplicates function? A better way?

    Try this one

    Please Login or Register  to view this content.
    Kind regards
    Leo

  3. #3
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,380

    Re: Deleting an entire row using a removeduplicates function? A better way?

    Forgot something

    Please Login or Register  to view this content.
    Kind regards
    Leo

  4. #4
    Registered User
    Join Date
    12-27-2012
    Location
    Fort Wayne, Indiana
    MS-Off Ver
    Excel 2007
    Posts
    17

    Re: Deleting an entire row using a removeduplicates function? A better way?

    Wow... I wish this site had a "donation" feature. Great work!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. This code not deleting entire row
    By biznez in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-20-2015, 11:38 AM
  2. [SOLVED] Deleting entire row on condition
    By Andrew.Trevayne in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-06-2013, 06:23 AM
  3. VBA for deleting entire rows
    By TheTalentedMrRipley in forum Excel General
    Replies: 3
    Last Post: 11-04-2010, 07:31 PM
  4. Deleting entire row if value in column A = 0
    By pyufak in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-07-2009, 05:43 PM
  5. Deleting entire row.
    By mangesh in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-07-2006, 04:37 PM
  6. Deleting entire row.... final question
    By Pam Field in forum Excel General
    Replies: 3
    Last Post: 07-23-2006, 08:35 AM
  7. Deleting Entire Rows
    By gavsta in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-19-2005, 12:45 AM

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