Delete Empty Cells With VBA

Hi All

I need a vba that will delete all cells with value of "" or zero, not deleting the row or the column just deleting any contents, so that a hide row macro ( which i have set up) will not pick up these "" values & regard them as nonblank.

Thanks
Mark