View Single Post
  #28   Report Post  
Posted to microsoft.public.excel.misc
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default Activate a workbook?

Hi Terry,

Am Thu, 09 Mar 2017 09:33:00 +0000 schrieb Terry Pinnell:

I was mistaken there, of course. The FORMAT gets copied but not the
formula. Is there a change I can make to achieve that please? Otherwise
I can do it manually.


change xlPasteValuesAndNumberFormats to
xlPasteAll

Regards
Claus B.
--
Windows10
Office 2016