Thanks cytop....
User presses <Delete> key on cell A1, code checks to see if cell A1 has changed and if it is blank. If it is blank it calls up 'Row.Clear';
'Row.Clear' calls up a window and the user has two buttons, <yes> and <no>. If <yes> is chosen, the following code is used;
As it is at the moment, when <delete> is pressed, the contents of the cell is deleted before the script is run - I don't want that to happen.
Is it the same code as above and how do I merge that code into the above.?
Thank you again.
Bookmarks