View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Peter T[_8_] Peter T[_8_] is offline
external usenet poster
 
Posts: 88
Default Save rich text somewhere in Excel?


"RG III" wrote in message

On Saturday, September 14, 2019 at 2:01:33 AM UTC-7, Peter T wrote:

Try PasteSpecial HTML


This might work, except that it pastes each paragraph in a different row.

Now I just need to create a macro that reassembles the rich text into it's
original single glob and copies it back into the clipboard.


Adjust the columnwidth to same as the Word doc's margins. Format with
word-wrap, if necessary 'AutoFit' row heights.

Peter T