Mitch,

Chip Pearson has an excellent explanation and examples at
http://www.cpearson.com/Excel/clipboard.aspx


Steve Yandl



"Mitch Powell" wrote in message
...
I need to copy some text to the clipboard using vba so that is will be
available in another application. For various reasons, I cannot use the
native Excel Copy function in this case. I can find no way to do this.
Surely I am missing something obvious.