I have a macro below to delete several items in Col C
When running the macro I get a run time error 450 "wrong number of arguments or invalid property assignment"
It would be appreciated if someone could assist me
When running the macro I get a run time error 450 "wrong number of arguments or invalid property assignment"
It would be appreciated if someone could assist me
Code:
Sub Delete_unwantedData ()
With Sheets("accounts")
With Sheets("accounts").Cells(1).CurrentRegion
.AutoFilter 3, "922205", xlOr, "", "714105", "714198", "922277"
.Offset(1).SpecialCells(12).EntireRow.Delete
.AutoFilter
End With
End With
End Sub