Sending 3 email?
I got it to only send ONE!!
What I did was change the email routine to "SelectionChange" and put this
code under "Calculate"
Private Sub Worksheet_Calculate()
Set Target = Range("HK2")
If Target.Value = "YES" Then
Application.Goto Range("HL2")
End If
Now, when it calculates and there is a YES in HK2 then it goes to HL2 and
that makes the SelectionChange fire!
Thanks so much for all your help!
|