[QUOTE=Joe.RBI;4817504]This is the code that I have come up with but it won't run. Doesn't give any errors, just doesn't run.


Why are you not following the example I gave and ignoring the advice? There is no need to name the sheet since you are using a sheet change event. The sheet name is irrelevant.

You are also hard coding a cell reference. That's not good practice. You were advised to use a range name.