You are welcome.
It certainly is a bit weird, - I had a quick look at what happens taking a macro recording while doing the various Copy and paste actions discussed here.
_1) ' Hit Enter after either
a Range Copy Method and Worksheets Paste Method
or
after a Range Copy Method and Range PasteSpecial Method
_ Result :
A worksheets Paste Method is done and then the Clipboard is emptied.
_2) ' Click on a Blank Cell and Hit Enter after doing a Worksheets Paste Method or Range Paste Special Method
_Result:
Clipboard is emptied
_3) ' Click on a non Blank Cell and Hit Enter after doing a Worksheets Paste Method or Range Paste Special Method
_ Result :
A worksheets Paste Method is done and then the Clipboard is emptied.
_4) ' Hit Esc Anytime
_ Result:
Clipboard is emptied
I have no idea to the logic behind the first 3
As I mentioned, not worth taking this one much further – it is crazy what goes on with the Clipboard.
Would be nice to be able to “see” all the versions of a copy that are there.. I expect that can be done ??
Bookmarks