Hello, everyone (´• ᵕ •`)
Does anyone know why when I use this code below I can't copy and paste other Ranges?
For instance, if I copy Range("A2") and then select Range("A3") to paste the value the sheet automatically interrupt the copy-paste process (as if I were pressing the Delete button)
HTML Code:
Last edited by BiaMidori; 10-18-2021 at 11:10 AM.
The action in your SelectionChange event clears the clipboard (just as if you did it manually)
Rory
Understood! Thanks for the quick response, rorya!
You could work around that by testing the Application.cutcopymode setting and only running your selectionchange code if it's false.
Great idea! I've used the code below and it worked beautifully, now I can copy and paste other Ranges. Thank you very much (＾▽＾)
HTML Code:
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks