Is there a way NOT to override a formula?????

[sssb2000]

hi,
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?

 

[sssb2000]

well,
this is what i ended up doing:

i created a new column
IF my condition was met and i was ready to add a 1 to the cell with the formula, i instead put a 1 in the corresponding cell in the new column.
and all i did was modify my formula to always look at its corresponding cell in the new column. This way, if a 1 was added, my formula cell's number would automatically be modified, and if a 1 was NOT added, the cell would posses its original value from the formula.


Do you know what i mean?

 

[Greg Truby]

Hey, if that solution works for you, in the end, that's all that matters.

 

[sssb2000]

yeah, it works great.

Thank you for all of your help


Kev.