run macro depending on cell value

[bamaisgreat]

I have the code below in my worksheet. I keep getting the ambigous error. The last section of code is what im trouble with. Thanks as always.

Private Sub Worksheet_Change(ByVal Target As Range)
    Dim cell As Range
    If Not Intersect(Target, Range("I4:I20")) Is Nothing Then
        Application.EnableEvents = False
        For Each cell In Intersect(Target, Range("I4:I20"))
            If Not IsEmpty(cell) Then
                Cells(cell.Row, "S").Value = Now
            Else
                Cells(cell.Row, "S").ClearContents
            End If
        Next cell
        Application.EnableEvents = True
    End If
End Sub
Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)




    If Target.Address = "$G$1:$J$1" Then
        Call FINALIZED_BY_QC_job
    ElseIf Target.Address = "$B$9,$B$11" Then
        Call SHOW_LIST
    End If
    End Sub


Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address <> "$V$1" Then Exit Sub
If Target.Value = "Email" Then Call Email8 'macroname sunday


End Sub

 

[Joe4]

Maybe try adding them to the Procedures you are calling instead.