Macro to run when cell changes
You haven't changed anything so your event won't fire.
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$AE$1573" < "" Then
Mail_small_Text_Outlook
End If
End Sub
Gord Dibben MS Excel MVP
On Thu, 9 Oct 2008 09:32:49 -0700 (PDT), newguy wrote:
I am trying to get this code to work that when the cell value changes
it calls another macro that sends and email but I can't get it to send
the email. The other macro on it own works.
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$AE$1573" Then
Mail_small_Text_Outlook
End If
End Sub
|