Click here to Skip to main content
15,940,373 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
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...
Posted
Comments
RedDk 2-Sep-13 21:05pm    
Excel spreadsheet? Have you tried using F2 to "enter" the cell before you paste? Note the red "X" and green "check". Both of these do the same thing but from the interface.

1 solution

monitor the clipboard... .NET has some rich clipboard features :)
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900