In
' By Chip Pearson
' chip@cpearson.com
' www.cpearson.com/Excel/Clipboard.aspx
' Date: 15-December-2008
Chip uses
Private Declare PtrSafe Function EmptyClipboard Lib "user32" () As Long
to clear the Clipboard
I'm not sure if CutCopyMode clears the clipboard also
https://learn.microsoft.com/en-us/of...6)%26rd%3Dtrue
Application.CutCopyMode property (Excel)
Returns or sets the status of Cut or Copy mode. Can be True, False, or an XLCutCopyMode constant, as shown in the following tables. Read/write Long.