Macro: Compile error: Ambiguous name detected: test

[JHaug]

Hello All,


I am attempting to run a macro but I am struggling with it, when I have the same macro format(I'm unsure of the correct terminology to use for it), the one difference is that I'm changing the rows with certain text that it's deleting. Although when I go to run the macro, it's telling me "Compile error: Ambiguous name detected: test". Can someone dummy it down for me and tell me what I'm doing wrong here?

Below is the code I am using for the macro, essentially the page breaks pull the same headers when exporting so rather than scrolling and deleting them all, why not make this easier and create the macro.

I would appreciate all help here!

Sub test()
With ActiveSheet
    .AutoFilterMode = False
    With Range("a1", Range("a" & Rows.Count).End(xlUp))
        .AutoFilter 1, "*System:*"
        On Error Resume Next
        .Offset(1).SpecialCells(12).EntireRow.Delete
    End With
    .AutoFilterMode = False
End With
End Sub

Sub test()
With ActiveSheet
    .AutoFilterMode = False
    With Range("a1", Range("a" & Rows.Count).End(xlUp))
        .AutoFilter 1, "*ACI Support Specialists, LLC*"
        On Error Resume Next
        .Offset(1).SpecialCells(12).EntireRow.Delete
    End With
    .AutoFilterMode = False
End With
End Sub

Sub test()
With ActiveSheet
    .AutoFilterMode = False
    With Range("a1", Range("a" & Rows.Count).End(xlUp))
        .AutoFilter 1, "*Original*"
        On Error Resume Next
        .Offset(1).SpecialCells(12).EntireRow.Delete
    End With
    .AutoFilterMode = False
End With
End Sub