Forum Discussion
Solved
VBA Code for sending email not working
I am using the following code in a workbook. The idea is that if a date is added in Column T, an email will generate that pulls other data into the body of the email and displays it before sending. I...
Click in the first line
Private Sub Worksheet_Change(ByVal Target As Range)and press F9 to set a breakpoint.
Enter or edit a date in a cell in column T.
The code will pause at the breakpoint.
Press F8 repeatedly to execute the code line by line, and observe carefully at which point it suddenly stops.
I figured it out. I wasn't paying attention and had inserted the code into a module instead of where it needed to be. Sorry to waste your time!
Glad you found it!