View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
billinr billinr is offline
external usenet poster
 
Posts: 38
Default Clear contents, keep formulas

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.