Clear contents, keep formulas

G

Guest

I have a workbook with several sheets; they all interact with various
formulas and macros.
This workbook will need to be "reset" at the end of the year.

My question is: how can I essentially do a "Clear Contents" throughout the
workbook, and keep all the formulas intact?

Thanks for the help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro for clearing cell contents 5
Copy Excel sheets 1
Special Pasting a work book with many sheets and formulas 2
How to copy an Excel worksheet with formulas and clear contents. 2
How to save formulas when creating templates 4
problems getting this macro to work 23
save workbook, erase data but keep formula 4
Copy Paste Values - Entire Workbook and Save 1

Top