Excel Programming with Macro

I want to create a macro that can delete same data from the current region. Also can delete the cell which contain nothing in it or with 0.00 value. The same data should be in the range. If a single item with else value the process will stop. Started from the next region.