![]() |
#2
|
||||
|
||||
![]()
Try this version for the duplicate row deletion
Code:
Public Sub DeleteDuplicateRows2() Dim xTable As Table, xRow As Range, xStr As String, xDic As Object Dim I As Long, J As Long, KK As Long, xNum As Long, iRow As Long, iRows As Long Dim aRng As Range, cRng As Range 'Application.ScreenUpdating = False Set xDic = CreateObject("Scripting.Dictionary") If Selection.Tables.Count = 0 Then MsgBox "Macro must be run when a table is selected" Exit Sub Else Set xTable = Selection.Tables(1) iRows = xTable.Rows.Count For I = iRows To 3 Step -1 Set aRng = xTable.Rows(I).Range aRng.Start = aRng.Cells(2).Range.Start For iRow = 3 To I - 1 Set cRng = xTable.Rows(iRow).Range cRng.Start = cRng.Cells(2).Range.Start If aRng.Text = cRng.Text Then xTable.Rows(I).Delete Exit For End If Next iRow Next I End If Application.ScreenUpdating = True End Sub
__________________
Andrew Lockton Chrysalis Design, Melbourne Australia |
Tags |
delete, identical |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
Richystab | Mail Merge | 3 | 12-07-2020 03:05 AM |
Identical computers | MeCasa | Office | 0 | 09-23-2019 03:43 PM |
Removing duplicate rows when identical value in a column | ballpoint | Excel | 1 | 01-05-2018 08:54 AM |
how to delete every blank and non-numeric rows without removing the header | enuff | Excel | 3 | 08-24-2017 05:56 AM |
![]() |
Bill K | Word | 1 | 12-03-2015 12:16 AM |