View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
Gee Gee is offline
external usenet poster
 
Posts: 32
Default 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!