Results 1 to 5 of 5

Removing Duplicates Entries from each column with a for loop.

Threaded View

  1. #1
    Registered User
    Join Date
    03-19-2013
    Location
    Indian Head, MD
    MS-Off Ver
    Excel 2010
    Posts
    3

    Removing Duplicates Entries from each column with a for loop.

    All, I am trying to use a For loop to parse a spreadsheet where each column is a computer and remove duplicate software entries in the column. This individual macro code works.

     Sub Remove_Dups()
        
        Columns("A:A").EntireColumn.Select
        Range("A1:A20").RemoveDuplicates Columns:=1, Header:=xlYes
       
        Columns("B:B").EntireColumn.Select
        Range("B1:B20").RemoveDuplicates Columns:=1, Header:=xlYes
       
        Columns("C:C").EntireColumn.Select
        Range("C1:C20").RemoveDuplicates Columns:=1, Header:=xlYes
       
        Columns("D:D").EntireColumn.Select
        Range("D1:D20").RemoveDuplicates Columns:=1, Header:=xlYes
       
        Columns("E:E").EntireColumn.Select
        Range("E1:E20").RemoveDuplicates Columns:=1, Header:=xlYes
       
        Columns("F:F").EntireColumn.Select
        Range("F1:F20").RemoveDuplicates Columns:=1, Header:=xlYes
        
        Columns("G:G").EntireColumn.Select
        Range("G1:G20").RemoveDuplicates Columns:=1, Header:=xlYes
        
        Columns("H:H").EntireColumn.Select
        Range("H1:H20").RemoveDuplicates Columns:=1, Header:=xlYes
        
        
    End Sub
    
    When I try to use a for loop it does nothing.
    
    Sub Remove_Dups()
    
    Dim col As Integer
    
     For col = 1 To 8
       Columns("A:A").EntireColumn.Select
       Range(Cells(col, 1), Cells(col, 20)).RemoveDuplicates Columns:=1, Header:=xlYes
     Next col
    
    End Sub
    Thanks for the help.
    TonyM
    Attached Files Attached Files
    Last edited by TonyM-2010; 03-19-2013 at 10:17 AM.

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