Marc

Application.CutCopyMode = False before your End Sub

Gord Dibben XL2002

On Wed, 26 Nov 2003 09:01:16 -0800, "Marc" wrote:

Hi,

Is there a command line that will clear the contents of
the clipboard automatically as part of a macro?

Thanks,

marc

Hi Mark..

I used this code written by Chip Pearson... worked for me

Public Sub ClearClipboard()
Dim MyDataObj As New DataObject
MyDataObj.SetText ""
MyDataObj.PutInClipboard
End Sub

Application.CutCopyMode = False :didn't work in my case


seeya ste