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