I have VBA code in my spreadsheet that looks at the values of certain cells and carries out Else/IF statements based on them. What I need to figure out is how to ensure that my code doesn't send an auto email to someone if there is a date already in the Email Sent field (row P) ' Check if due date is soon If Len(sh.Cells(cl.Row, "N")) = 0 And cl.Value <= DueDate And sh.Cells(cl.Row, "P") <> TodayDate Then ' Check due or overdue If cl.Value < TodayDate Then TypeDue = TodayDate - cl.Value & " days overdue." Else TypeDue = "due in " & DueDate - TodayDate & " days" End If
Solved by G. J. in 28 mins