VBA Code to remove Zero from Cells

[ARJUNDSOUZA]

I have tried recording macros doing the Control+Find / Replace option but land-up with incorrect output. Normally end up removing the '0' from 10,20 and 30 not what I want...

Code needed to do the following:
1) Cell B4:O8 - Look for '0' (Zero) - not the 10,20,30.... (basically anything less than 1)
2) Replace it as blank or null
3) Cell Range is not limited to B4:O8 but could be B4:O20 - the table keeps changing.

Would really appreciate any assistance possible.

Thanks in advance.

 

[Marc L]

Your bad : when you operate manually you must choose the appropriate option like for the whole cell content instead of a cell part …​

​

 

[ARJUNDSOUZA]

Dear Marc,

Apologies, I do not understand. Can you assist in solving the issue.

 

[Marc L]

As no code was posted just activate the Macro Recorder and operate manually :​

if the result is the expected one so you well answered to the search assistant then​

the generated code has now all the necessary, just compare with the former one …​

​

Another easy way is to just read the VBA inner help of the method used within the code​

where you can easily see which parameter you must correct …​

​

 

[ARJUNDSOUZA]

Thank you Marc, got it!
Task completed.

 

[Marc L]

Well done !​

​