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
|