How have text on clipboard reformatted as a cell would be put there?

[RandyDtg1]

If I select a cell, and copy, it goes to the clipboard differently than if I
select the text from the formula bar. (I know, formatting gets included).
My problem is, I have an external application that can not paste unless it is
in the format of a copied cell !!!

So, how can I convert a text only entry on the clipboard to one that looks like
it was copied as a cell?

I'd like to do this in VB.

 

[Tom Ogilvy]

You can't unless you put it in a cell and copy it.

 

[RandyDtg1]

Is there a way to manipulate the clipboard to do this?

I want to make text that was copied, look like a cell copied to the clipboard.

 

[Tom Ogilvy]

Sorry I wasn't clear. No, you can not do this.

--
Regards,
Tom Ogilvy

Is there a way to manipulate the clipboard to do this?

I want to make text that was copied, look like a cell copied to the

clipboard.