Set error cells = 0

[yuryyuryyury]

Is there a macro or method to find all the error cells in a range, highlight it, and enter a zero in the cell?

[VBA Noob]

Try

Please Login or Register  to view this content.

VBA Noob

[yuryyuryyury]

that worked well, but i realized that some of the error messages i was getting are custom types, so a couple still remain.

[VBA Noob]

realized that some of the error messages i was getting are custom types

Can you give an example of what you mean by this

VBA Noob

[yuryyuryyury]

I am using bloomberg, so the errors i'm getting are like "#N/A History" and others. I'm checking with them if they have something already made for this.

[VBA Noob]

Is #N/A the only error in string to find

VBA Noob

[yuryyuryyury]

i think so.. so far that's the common thing i'm seeing.

[VBA Noob]

Maybe

Please Login or Register  to view this content.

VBA Noob

[yuryyuryyury]

it works..

if i want to specify certain ranges, can i use this:

Please Login or Register  to view this content.

[VBA Noob]

Maybe

Please Login or Register  to view this content.

VBA Noob