Help with inserting a name & date stamp when multiple cells are pasted or dragged

[_H_]

Hi,

I have this piece of code to insert a username and date stamp when someone edits column L to say approved or rejected.

Please Login or Register  to view this content.

I have managed to stop the error message when copying and pasting into multiple cells by using a message box but wonder how I now alter this code so that regardless of whether the end user selects each cell individually to approve/reject or drags/copies into multiple cells the username and date stamp still appears. Can anyone help?

[Bernie Deitrick]

Try it like this:

Please Login or Register  to view this content.

[_H_]

Thank you so much Bernie! That works brilliantly!