quick question....

i have a cell with a formula.....and a macro that depending on certain conditions adds a 1 to that cell.

Now the problem is that once that 1 is added to the cell, the formula is getting erased and instead, a number is replaced. The number is in fact the correct number, but i need to have a formula in there for future uses.

Is there anyway to have the cell keep it's formula?