Thread: Run Time error 1004 - Pastespecial method of range class failed.
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
oli merge oli merge is offline
external usenet poster
  
Posts: 50
Default Run Time error 1004 - Pastespecial method of range class faile
Just to note though, I had to use "xlPasteAllUsingSourceTheme" to keep my
formatting (lots of bold and underlined words).

Thanks,

"oli merge" wrote:

Perfect, thanks for tidying up my messy recorded code too!


Reply With QuoteReply With Quote