VBA clear contents if cell contains

[Revathi kannan]

Hi all,

Please assist me on the below.

> I want to clear only the cell in Column B if my cell contains any negative value, 0 and #NUM.
> I have highlighted the cell for easy understandings. Please refer the attached file.


Thank you.

[Bo_Ry]

Please try

Please Login or Register  to view this content.

[Revathi kannan]

Thanks a lot for your help. it works perfectly.