Is it possible to return a cell to zero after it displays a minus number
result in a cell. ?

The minus result is the result of code being run and it can result in more
than one cell in a range eg A1:A10

I do not want a formula to be used.

Any pointers on this will be most appreciated.
Pat