changing this macro

[sabsx]

hi!

I want to change the following macro in a way that it deletes not the highlighted column but column C:

Public Sub DeleteDuplicateRows()

Dim R As Long
Dim N As Long
Dim V As Variant
Dim Rng As Range

On Error GoTo EndMacro
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual


Set Rng = Application.Intersect(ActiveSheet.UsedRange, _
ActiveSheet.Columns(ActiveCell.Column))

Application.StatusBar = "Processing Row: " & Format(Rng.Row, "#,##0")

N = 0
For R = Rng.Rows.Count To 2 Step -1
If R Mod 500 = 0 Then
Application.StatusBar = "Processing Row: " & Format(R, "#,##0")
End If

V = Rng.Cells(R, 1).Value

If V = vbNullString Then
If Application.WorksheetFunction.CountIf(Rng.Columns(1), vbNullString) > 1 Then
Rng.Rows(R).EntireRow.Delete
N = N + 1
End If
Else
If Application.WorksheetFunction.CountIf(Rng.Columns(1), V) > 1 Then
Rng.Rows(R).EntireRow.Delete
N = N + 1
End If
End If
Next R

EndMacro:
End Sub

 

[Derek Brown]

Not sure that you really want to make just that change. The code performs actions in a loop (working backwards from the last row). You will end up deleting Column C every time you find a duplicate row so, for example, after finding the second duplicate row you will have deleted Column C and Column D (which will have 'replaced' Column C after the first delete).
Is that what you really want to do?