Hi,
I'm trying to make an event macro to be triggered when a cell in a range is changed or deleted.
For example, if the target range is set to B1:B10 and cell b5 is changed, then c5 = "text". If cell b9 is empty or deleted, then c9 = "".
Any ideas/help?
Let me know if you need more detail.
Nick