When I try and run this code I receive a User-defined type not defined ERROR
how do I set MyDataObj in Excel2003

"ste mac" wrote:

Hi, try this, its one of Chips.. l use it all the time..

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

seeya ste