When I attempt to copy and paste items from clipboard it seems to automatically remove some of the items when I paste them. Attached is the document where this occurs. I used the "Paste All" button in clipboard. I need this to work for a macro I'm trying to develop.
Can't get it to replicate what you are seeing, I tried copy/paste, copy a series then paste all - worked, then copy paste special all and transpose and it worked.
Can you define further which values you are copying and pasting that are being removed?
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
Starting from C1R1 I use ctrl+shift+down arrow to select my column. Then copy it to my clipboard. Then Right Arrow to go to C2R1 and repeat the process until I've selected all the data I want in the clipboard. I will then paste in an open cell.
Last edited by SDings; 05-30-2018 at 11:10 AM. Reason: adding image
Attached is an example of it not pasting everything in the clipboard. In C1R7 I clicked "Paste All" in the Clipboard and not everything pasted. In C3R7 I clicked "Paste All" in the Clipboard and not everything pasted. In C5R7 I clicked "Paste All" in the Clipboard and not everything pasted.
Gotta admit I never did it that way before so I learned something new. BUT, I tried to repeat your process, I cleared all the cells you had from R8C1 (or A8) and then used paste all and it filled in each row going down to row52 and nothing was lost from the original data I copied.
I think I see what you are saying it is doing now.
It is puzzling, it seems to bring down the data intermittently, sometimes all the data copied and other times incomplete, leaving some out.
Last edited by Sam Capricci; 05-30-2018 at 11:41 AM.
Exactly my thoughts. I don't tamper with the settings, either. So I'm not entirely sure why it's doing this. I've tried researching it but nothing immediate comes up with assistance so I've resorted to posting it here hoping someone could figure out why it's doing this.
I've attempted to clear the cells I've used as examples and redo the process but to no avail. Interestingly enough, when I Paste All in the exact same three locations as last time, it doesn't paste incorrectly the same way as before but incorrectly a different way. Image showing my second attempt attached.
I've done testing on my machine. No issues after 100 iteration of paste all.
I suspect this is related to some add-in or software interfering with Office Clipboard.
Test by turning off all add-in's.
Some cloud-drive syncing software has been known to cause some issue with Office (DropBox if I recall).
Personally, I'm not a fan of using Office Clipboard in code, as it isn't easy to clear items from it. See link below.
https://www.excelforum.com/excel-pro...ode-false.html
I prefer to use Union, array etc for transferring data.
?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
― Robert A. Heinlein
I've looked in my add-ins window and it doesn't appear that I have any add-ins turned on.
Interesting CK, I have SmartView (for Essbase cube data), Fuzzy Lookup and Acrobat added to my excel. And it failed more often that it worked for me. Hmmm.
Although this continues to occur. I did decide to make a macro work around for my specific needs. So I don't need an answer to this anymore, but I will give reputation for the quick responses and helpful advice.
thank you for the rep!
Best of luck and thanks for the rep
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks