Resolving An Ambiguous Name Error

[Ark68]

My code used to work. I don't know now why I am getting a "Compile Error: Ambiguous name detected: ~" with the line highlighted in red below.

Private Sub Worksheet_Change(ByVal target As Range)
'Application.EnableEvents = False
    Dim wshmain As Worksheet
    Dim wshlists As Worksheet
    
    Set wshmain = Worksheets("Main")
    Set wshlists = Worksheets("Lists")
    
    Select Case target.Address(0, 0)
        'call procedure when cell D1 (report date) changes
        Case "D1"   'New Date Entered
            Call Test 'test to determine whether reconciled database exists. Create missing database, or open existing database.

I stepped through the 'Test' sub and didn't receive any errors, so not sure what this is all about.

 

[Andrew Poulsom]

Do you have more than one procedure named Test, or a name and a procedure named Test?

 

[Ark68]

Hi Andrew ... yes. I did. Looks like I used the same name for an experimental sub that I didn't delete.
Found the problem.
Had the same sub twice.

Thanks!