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
Sub Makro1() ' http://www.excelforum.com/showthread.php?t=1162752&p=4519471#post4519471
'
'
'
' Hit Enter after a Copy and Paste or after a Copy and PasteSpecial
1 ActiveSheet.Paste: Application.CutCopyMode = False ' Worksheets Function Paste: Empty Clipboard
' Click on Blank Cell and Hit Enter after doing a Paste or Paste Specilal somewhere.
2 Application.CutCopyMode = False ' Empty Clipboard
' Click on a non Blank Cell and Hit Enter after doing a Paste or paste Special
3 ActiveSheet.Paste: Application.CutCopyMode = False ' Worksheets Function Paste: Empty Clipboard
' Hit Esc Anytime
4 Application.CutCopyMode = False 'Empty Clipboard
End Sub
' Rem Ref
' http://www.mrexcel.com/forum/excel-questions/727407-visual-basic-applications-split-data-into-multiple-worksheets-based-column-4.html#post4039255
' http://www.mrexcel.com/forum/excel-questions/828241-visual-basic-applications-autofilter-specialcells-xlcelltypevisible-copy-only-values-not-formulas.html#post4043472
' http://www.eileenslounge.com/viewtopic.php?f=27&t=25002&p=193871#p193871
' ' http://www.eileenslounge.com/viewtopic.php?f=27&t=22512
' http://www.excelforum.com/showthread.php?t=1144116&p=4414189&highlight=#post4414189
' http://www.excelforum.com/showthread.php?t=1114014&page=3&p=4256195#post4256195
' http://www.mrexcel.com/forum/excel-questions/828241-visual-basic-applications-autofilter-specialcells-xlcelltypevisible-copy-only-values-not-formulas.html#post4043472
' http://www.mrexcel.com/forum/excel-questions/785462-visual-basic-applications-copy-value-paste-worksheet-same-name-value-3.html#post4071766
' http://www.excelforum.com/excel-programming-vba-macros/1159780-syntax-problem-with-intersect-statement.html#post4504411
' http://www.excelforum.com/tips-and-tutorials/1108643-vba-column-letter-from-column-number-explained.html
' https://app.box.com/s/lts3h2ejf33yj2i2xmaq5zrq784qwwl9
' http://www.excelforum.com/showthread.php?t=1114014&page=3&p=4256195#post4256195
' http://www.excelforum.com/showthread.php?t=1154829&page=2&p=4483347&posted=1#post4483344
' http://www.excelforum.com/showthread.php?t=1144116&p=4414189&highlight=#post4414189 'http://www.excelforum.com/showthread.php?t=1114014&page=3&p=4256195#post4256195
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