Thread: How have text on clipboard reformatted as a cell would be put there?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 27,285
Default 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.




Reply With QuoteReply With Quote