hi i am working on a macro in Excel and i use the Clipboard but before i proceed to next sub i want to clear the Clipboard. I use at the moment a way of copy empty cells to the clipboard. But i know there must be an other way.
reading forums and help files they gave me this help.
i have to use a API call
this one:
Declare Function EmptyClipboard Lib "user32" Alias "EmptyClipboard" () As Long
sub clearClipBrd()
EmptyClipboard
end sub
But i dont know how to use it in the macro.
please can someone help me with this?
greetings ....
reading forums and help files they gave me this help.
i have to use a API call
this one:
Declare Function EmptyClipboard Lib "user32" Alias "EmptyClipboard" () As Long
sub clearClipBrd()
EmptyClipboard
end sub
But i dont know how to use it in the macro.
please can someone help me with this?
greetings ....
