Can I turn of all #value! errors in a workbook

[rkjudy]

I have a workbook that contains several formulas that return #value! errors. My formulas are correct and I can remove the error by using an "if" function, but there are a lot of these cells. I just want to make the error show blank to make my workbook look nicer without having to write formulas to avoid the error messages. Is there something I can add in the VBA worksheet function to turn off these errors?

[Dave69rock]

Hi

Record a Macro to "find and replace" that should solve your problem

Dave

[Ron Coderre]

..I just want to make the error show blank to make my workbook look nicer without having to write formulas to avoid the error messages. Is there something I can add in the VBA worksheet function to turn off these errors?

Kind of like painting dirt and calling it a patio. Your workbook may look nice when you're done,
but I fear it'll just be a disaster waiting to happen. I recommend fixing the formulas and learning a lesson for next time.