vba code to clear contents of cell

Hello CodesRus,

Here is the amended macro. When you are working with either the Change or Selection Change events, you must disable Events and re-enable Events before exiting the macro if the code changes a a cell value or selects another cell. If you do not then Excel will most likely crash do to a cascade stack overflow error.

Please Login or Register  to view this content.