View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
the holster
 
Posts: n/a
Default HOW DO I PROTECT VALUES WHEN CREATING CLEAR CONTENTS MACRO?

I have successfully created a 'Clear Contents' button for a worksheet, so
that a new form can be started from scratch. However, I need to keep the
running balance from the previous week on the new sheet. If I clear the
entries, the running balance will also change. What formula can I use so as
to duplicate the true running balance total to the new sheet?