View Single Post
 
Old 11-28-2009, 12:04 PM
XJOutsider XJOutsider is offline
Regular
 
Join Date: Jun 2009
Posts: 66
Default Removing Duplicates

I am Tring to Make this work but I do not understand the Colunms as objects Part. Here is what I got

Code:
wbTemplateSAS.Sheets("Component Matrix").Activate()
        Dim MyRange2 As Excel.Range
        With wbTemplateSAS.Sheets("Component Matrix")
            MyRange2 = .Range("A2:AY2", .Range("A65536:AY65536").End(Excel.XlDirection.xlUp))
        End With
        MyRange2.RemoveDuplicates(Colunm:=(HELP HERE) ,XlYesNoGuess.xlYes)
This is what the VBA looks like
Code:
ActiveSheet.Range("$A$2:$AY$113").RemoveDuplicates Columns:=Array(1, 2, 3, 4, 5, _
        6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16), Header:=xlNo
    Sheets("SAS").Select
Reply With Quote