Replace Empty With Zero using Macro

Hi, guys working on excel spread sheet using macro to fill empty cells with 0 but the macro are deleting the formulas in the sheets.... can anyone help me please

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Moderator's Edit: Use code tags when posting code. To do so in future, select your code and click on the # icon at the top of your post window.

@tau84

I didn't dig into your second macro, but your first macro does what you mentioned. I just cleaned it up a bit below.

Please Login or Register  to view this content.

Moderator's Note: As per Forum Rule #12, please don't quote whole posts unless necessary…it's just clutter...Thanks.