Jim,

Thanks for your help. That worked for what I need to do.

Thanks again,

Conan


"Jim Rech" wrote in message
...
I'm not familiar with the technique you're using. Usually Excel
developers
just use a DataObject to put something in the clipboard:

Sub a()
Dim MyData As DataObject
Set MyData = New DataObject
MyData.SetText Format(Now, "Short Date")
MyData.PutInClipboard
End Sub

--
Jim