How delete the cliboard

[Aldo Miele]

I need to know under windows Xp how is possible thru a Excel Macro to delete
the values in the clipboard?

Clipboard.clear dosnt' work

 

[Etien]

Application.CutCopyMode = Fals

 

[Ron de Bruin]

Hi Aldo

After you paste use this line
Application.CutCopyMode = False

 

[Ed]

This is how I do it with Windows 2000 and Excel 2000:

Dim doFName As MSForms.DataObject

Set doFName = New DataObject

doFName.SetText ""

doFName.PutInClipboard ' clears clipboard



HTH

Ed