Thanks for all the help. I guess the easiest thing is to use another column. May try to write the event macro as I am always trying to learn new things. Thanks once again for sharing your knowledge.

Bob