Since this is Mike Alexander's code, you may want to ask him. But a suggestion may be to put the code in a Worksheet Change event with your input cell as your target.