Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Sub DeDupeListObject(lo As ListObject)
- ' deduplicate rows considering all columns
- Dim arr As Variant
- Dim i As Integer
- ReDim arr(0 To lo.ListColumns.Count - 1)
- For i = 0 To lo.ListColumns.Count - 1
- arr(i) = i + 1
- Next i
- lo.Range.RemoveDuplicates Columns:=(arr), Header:=xlYes
- End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement