VBA to remove standalone zeros

[thedeadzeds]

Hi Guys,

Is there a way to remove all standalone zeros in columns R to Y so

from this

0​

0​

0​

0​

0​

0​

0​

18192.02​

to this

18192.02​

As you can see column Y also has a zero but this needs to stay as is not a standalone zero.

Thanks

 

[Joe4]

Use "Find and Replace", replacing 0 with nothing, being sure to select the "Match entire cell contents" option, i.e.

and clicking "Replace All".

If you want VBA code for this, turn on your Macro Recorder and record yourself doing this manually.
Then stop the Macro Recorder and view the code, and you will have the VBA code that you need!

 

[Scott Huish]

If it doesn't affect any calculations and you just don't want to show them you can format the cells to not show them:
[=0]"";General