Thanks for the suggestions.

I believe I had both set that way.
But, this morning it is working!
So, I'll credit you with a win.


"TomPl" wrote:

1. Make sure the validation rule for A4 allows a blank value.
2. Make sure the code is in the worksheet, not in a module.

Tom