delete matches by vba (macro correction)

[zyxw1234]

Code: Select all

Sub Delete_Matches()
    Dim wb As Workbook
    Set wb = Workbooks.Open("C:UsersWolfieeeStyleDesktop1.xls")
    Set ws = wb.Worksheets.Item(1)
    With ws
    Application.ScreenUpdating = False
    Range("A1").EntireColumn.Insert
    Range("A1").CurrentRegion.Columns(1).FormulaR1C1 = "=RC[5]=RC[6]"
    Range("A1").CurrentRegion.AutoFilter Field:=1, Criteria1:="TRUE"
    With ActiveSheet.AutoFilter.Range
        On Error Resume Next
        .Offset(1).Resize(.Rows.Count - 1).SpecialCells(xlCellTypeVisible).EntireRow.Delete
        On Error GoTo 0
    End With
    ActiveSheet.AutoFilterMode = False
    Range("A1").EntireColumn.Delete
    Application.ScreenUpdating = True
    End With
    wb.Save
    wb.Close
End Sub

Hi Experts,
looking for a macro correction
Plz remove the on error resume next line in this macro

https://eileenslounge.com/viewtopic.php ... 7&p=236961

[HansV]

The line On Error Resume Next is there to ensure that you won't get an error message if there are no rows that satisfy the AutoFilter condition. Why do you want to remove it?

[zyxw1234]

On error resume next line (Professional coder's try to ignore these line in the macro & me too.. sir, it creates issues sometimes that's y)

[Leif]

Plz remove the on error resume next line in this macro

On error resume next line (Professional coder's try to ignore these line in the macro & me too.. sir, it creates issues sometimes that's y)

Can't you use your delete key?
Or have you never actually opened up the VBA editor yourself - you just rely on someone else to do everything for you?

[HansV]

What kind of issues does that line cause for you?

[zyxw1234]

This macro doesn't cause any issue
But it's recommended to alway's try to ignore this on error resume next line in the macro

[LisaGreen]

Recommended by whom?
Please quote your sources.
I'd really like to know. This is not a joke!!!

IMHO This is a regular and accepted method of catching errors in VBA.

Lisa

[zyxw1234]

No Problem Fine
I will use this only
Problem Solved

[LisaGreen]

So what are your sources then????

Lisa

[zyxw1234]

Means
My Mistake
Sorry for the same
No Sources