Hi Sean,

Am Tue, 22 Nov 2016 12:19:37 -0800 (PST) schrieb :

Claus, I have 2 Macro Buttons on the Report sheet, I will replicate these on the Template sheet, but how does your code below handle these, does it delete them from Report first? I've had other worksheets when the size explodes when you copy sheets in multiple times with Buttons

ClearContents only deletes cell values. Other things like buttons will
remain.


Regards
Claus B.
--
Windows10
Office 2016