Hi Ernst,

See JohnWalkenbach's Undo page:

http://www.j-walk.com/ss/excel/tips/tip23.htm

---
Regards,
Norman



wrote in message
...
Hello,

I have a piece of code that runs in the worksheet_Change event. I change
the target.value in the code. My question is that I want to create an
undo
for this. I need the value of target prior to the code being run. Any
ideas?

Thanks,
Ernst.