On Jul 16, 10:13*pm, Charlie
wrote:
...and if it DOES work save a copy as a template for future years!

"Terry Freedman" wrote:
Hi

I need to clear the data in 12 worksheets at once (Jan to Dec), but
leave the formulae intact. Any ideas on a quick way of doing that with
a macro please?

Thanks
Terry

worked brilliantly! Thanks, Charlie :-)