error omitting macro

[kemperohlmeyer]

Does anyone know any code for a macro that will automatically go through sheets and white out all errors (#N.A., #Value!, etc)?

ko

 

[SteveO59L]

What do you mean by "White Out " ?.

Surely, you would be better correcting the errors ?

 

[kemperohlmeyer]

I just mean to make the text white, so it's not visible. The file is linked to bloomberg, which gets finnicky at times and there's nothing you can really do about it. Therefore i just want to hide the errors.

thanks,
ko

 

[SteveO59L]

Try conditional format with an iserror() statement

 

[kemperohlmeyer]

The problem is that some "errors" are generated by the bloomberg program and are therefore not treated as errors. Essentially i need conditional formatting for more than 3 conditions. Thoughts?