VB Code to fill blank cells with zero

Hello:

Please refer to attached file.
I have data in column D,E,F and G from row 6 down.
i need a simple VB Code to check if any of the cell is blank, then add "0.00"

Let me know if you have any questions.
Thanks.
Riz

Hi Riz,
maybe so

Please Login or Register  to view this content.

Hi Nilem:

Thanks a lot...works
Riz