View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Clear contents, keep formulas

Edit Goto... Special Constants
Edit Clear Contents
--
Gary''s Student - gsnu200751


"billinr" wrote:

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.