Results 1 to 13 of 13

Add auto filter (unique records) option to macro

Threaded View

  1. #11
    Registered User
    Join Date
    12-17-2009
    Location
    Boston, MA
    MS-Off Ver
    Excel 2002
    Posts
    15

    Re: Add auto filter (unique records) option to macro

    Hi Pike, I added in a new definition:

    Sub DelDups()
      Application.ScreenUpdating = False
      Dim deleted As Boolean
      deleted = True
      While deleted = True
        deleted = False
        For Each x In Sheets("RESULTS").Range("A2:A100")
           For Each y In Sheets("RESULTS").Range("A2:A100")
             If x.Row <> y.Row Then
               If x.Text = y.Text And y.Text <> "" Then
                 Sheets("RESULTS").Rows(y.Row).Delete xlShiftUp
                 deleted = True
               End If
             End If
           Next
        Next
      Wend
      Application.ScreenUpdating = True
    End Sub
    I've attached the finished workbook in case anyone else needs it as well.
    Attached Files Attached Files

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