Locking a cell
 

I need to have some cells add and delete in one column. At the end of each
day i need to clear everything out, but have the total at the bottom of the
page appear at the top of the column. I have tried this, but when ever i hit
the clear macro, it puts a zero at the top. Any idea how to lock that cell
so it will not clear?

Locking a cell
 

John
You have a formula in that cell at the top. That formula sums whatever
is written in the formula. When you clear the cells that this formula sums,
you will get the sum of those cells, zero. The only way to "freeze" that
number is to remove the formula and replace it with the number that was
displayed in that cell before you cleared the cells.
To do this, select that cell (the one at the top that sums all the other
cells). Do this before you clear the cells. Click on Edit - Copy. With
that cell still selected click on Edit - Paste Special. Click on Values.
Click OK. The formula is now gone and the number is still there. HTH
Otto
"John" wrote in message
...
I need to have some cells add and delete in one column. At the end of each
day i need to clear everything out, but have the total at the bottom of
the
page appear at the top of the column. I have tried this, but when ever i
hit
the clear macro, it puts a zero at the top. Any idea how to lock that
cell
so it will not clear?