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?