Need Help with code to monitor cell AB1, which counts certain words in a range. When AB1 is greater than zero, the system send an email to alert manager. Also Is there a way to increase the base value of AB1 as the number goes up, without manually changing it from 0 to 1 to 2 etc. Also need help with code to send the email. Everything I do keeps prompting me to select the email to send.
Any ideas you have will help I know nothing about VBA
Any ideas you have will help I know nothing about VBA
Last edited by a moderator: