Remove Duplicates Col

[billandrew]

Not sure why this is not removing the duplicates in Column C. Any help would be appreciated.

Sheets("Sheet7").Range("C1:C100").RemoveDuplicates Columns:=3, Header:=xlNo

 

[billandrew]

Trying to make this dynamic as well. This is how I am attempting this.

Dim FinalRow As Long        FinalRow = Cells(Rows.Count, "C").End(xlUp).Row
        With Range("C" & FinalRow)
        .Removeduplicates Columns:=3, Header:=xlNo
        End With

 

[billandrew]

I believe I have it. Columns should be a 1....

Thanks

Dim FinalRow As Long        FinalRow = Cells(Rows.Count, "C").End(xlUp).Row
        With Range("C1:C" & FinalRow)
        .Removeduplicates Columns:=[COLOR=#ff0000]1[/COLOR], Header:=xlNo
        End With