I think first chance I get I will take a class to learn how to use VBA in depth because this seems to be getting more complicated then I thought it would be. I will try playing with this new code tomorrow. is there not a way to put the formula I have in R26 in the code for email notifications so they both trigger at the same time? or even a different way to do the notification part of this other then an email that I just don't know about?