Macro needed for changing cells to zero.

Hello all,

I need a macro in a sheet to put all the values in a certain area to zero.
The Cells contain formulas and they need to stay in there.

So i basically need a Macro that adds a plus to the formula with the value that is on that moment in that Cell..! And then in a certain area.

Macro_Minus.xlsm

If you look in the attachment, then i need a macro that makes all the values 0 in CELLS E9 : CQ1010.

Can anyone help me with this?
Thanks in advance!

Hi jorislande,
maybe so

Please Login or Register  to view this content.

Hi Nilem,

Yes almost!!
Only i want to keep all the values that are positive. Only the negative values i want to reset to zero.
Is that possible aswell?

Thanks!

try so

Please Login or Register  to view this content.

Yess! Thank you very much!
It works perfectly.

One last question, is it also possible that the cells that have been set top zero with the Macro change into red or something like that?

Please Login or Register  to view this content.

Thanks for your help!