Quote Originally Posted by xld
Use the selectionchange event to capture the value before changing it.
i tried it but it helps when I delete one cell in a row.Still haven't figured out how to do for an entire row.What I need is when I delete a row say row 3, then row3 should have a red color border and a comment on it which tells me the deleted value.