Hello guys., i have found this code and tried it out., upon checking., it seems it is applicable only for 2004 and below excel versions. is there other way to clear the clipboard in excel 2013? Option Explicit Public Declare Function OpenClipboard Lib "user32" (ByVal hwnd As Long) As Long Public Declare Function EmptyClipboard Lib "user32" () As Long Public Declare Function CloseClipboard Lib "user32" () As Long Public Function ClearClipboard() OpenClipboard (0&) EmptyClipboard CloseClipboard End Function Sub Test() Call ClearClipboard End Sub regards, melson
This question generated 25 answers. To proceed to the answers, click here.