Thread: Clipboard clear
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
RB Smissaert RB Smissaert is offline
external usenet poster
 
Posts: 2,452
Default Clipboard clear

Put at the top of the normal code module:
Private Declare Function EmptyClipboard Lib "user32" () As Long

Then where you want to clear the clipboard put:
Call EmptyClipboard

RBS


"Reuel" wrote in message
...
Is there any way to clear the clipboard in a macro run? I've been having
strange programmatic freezes after a long series of cut/paste/select
operations (see previous post by me) and I thought that it might help
force a
clear of the clipboard periodically.

Also, can anyone suggest another resource for help when no one inthis
forum
has a suggestion for solving Excel programming problems?
Thanks,