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

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.

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

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

--
Regards,
Tom Ogilvy

"RandyDtg1" wrote in message
...
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.

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

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.

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

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

--
Regards,
Tom Ogilvy

"RandyDtg1" wrote in message
...
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.