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

RandyDtg1 · Jun 12, 2004

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 · Jun 13, 2004

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

RandyDtg1 · Jun 14, 2004

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 · Jun 14, 2004

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

--
Regards,
Tom Ogilvy

RandyDtg1 said:
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.