我如何知道用户是否将单元格复制并粘贴到其他单元格？

我在worksheet_Change事件下创建了一个代码，现在我的问题是，当我将一个单元格复制到其他单元格时，它会将复制的值粘贴到该单元格，但是当我选择另一个单元格然后将其粘贴在那里它不粘贴任何东西。好像当我已经将内容粘贴到某个单元格中时，它会删除复制的值。



现在我的解决方案是保存所有内容剪贴板中复制的值，但我的问题是我不知道用户何时复制和单元格我是指复制单元格时它会触发什么事件？



请帮帮我...

i created a code under the worksheet_Change event, now my problem is that when i copy a cell to other cell it paste the copied value to that cell, but when i select another cell then paste it there it doesnt paste anything. it seems like when i already paste the content in a certain cell
it deletes the copied value.

now my solution is to save all the copied value in the clipboard, but my problem is i dont know when a user copied and cell i mean what event does it trigger when they copy a cell?

please please help me...