Email as CDO displays "0". Need to remove. HELP

[shophoney]

Hi I'm sending emails as CDO using Ron's code. I need to hide the emails from my staff as it contains financial information about the company.

Emailing works fine but now is doesn't hide the "0". And looks very cluttered.

I've turned it off from being displayed. But need to clean it up in the emails too.

It's to big to make formulas for each cell saying ..=0,""..

Thoughts?

Thanks