Advertisement
Guest User

dedupe listobject Excel VBA

a guest
Mar 22nd, 2017
116
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
VB.NET 0.34 KB | None | 0 0
  1. Sub DeDupeListObject(lo As ListObject)
  2.    
  3. ' deduplicate rows considering all columns
  4.     Dim arr As Variant
  5.     Dim i As Integer
  6.     ReDim arr(0 To lo.ListColumns.Count - 1)
  7.    
  8.     For i = 0 To lo.ListColumns.Count - 1
  9.         arr(i) = i + 1
  10.     Next i
  11.    
  12.     lo.Range.RemoveDuplicates Columns:=(arr), Header:=xlYes
  13.    
  14. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement