Macro to delete all #value! cells

[Jacek]

Hello everyone,

I am currently working with a worksheet that contains thousands of entries. Many of them contain formulas which are dependent on other entries. I'm having a handful of cells return #value!. It is not of great concern as to why this is being returned, but for plotting purposes, I would like to have these cells cleared with a macro.

Is this possible? Say I want the macro to scan a specific range for cells with that contents, and then clear those cells out.

Any help is greatly appreciated.

Thanks.

 

[Jacek]

Solved.