Script to remove any duplicate values in a column.
sheetObj.Range("O2:O" & lastRow).RemoveDuplicates Columns:=Array(1), Header:=xlNo
Script to remove any duplicate values in a column.
sheetObj.Range("O2:O" & lastRow).RemoveDuplicates Columns:=Array(1), Header:=xlNo