Hi,
Ive got this to work in sequence but ideally id like these as separate macro to trigger only if "h9" changes for example.
ANy assistance greatly appreciated.
Private Sub Worksheet_Change(ByVal Target As Range)
If Range("E9").Value = 5 Then CongratsEmail_1
If Range("E9").Value <> 5 Then
End If
If Range("H9").Value = 5 Then CongratsEmail_1
If Range("H9").Value <> 5 Then
End If
If Range("K9").Value = 5 Then CongratsEmail_1
If Range("K9").Value <> 5 Then
End If
If Range("N9").Value = 5 Then CongratsEmail_1
If Range("N9").Value <> 5 Then
End If
If Range("Q9").Value = 5 Then CongratsEmail_1
If Range("Q9").Value <> 5 Then
End If
End Sub
Bookmarks