finding error values with VBA code

Hi all,

I have a worksheet range (say a1:z500) with a lot of values in it, some of these values are errors, like # DIV /0!, # value!, etc...

I want to write a code which replaces all these error values with smth else like "n.a."

I assume this is a basic question, but I'm still at the early stages of learning this stuff..

Many thanks,
-levent

Originally Posted by levo_redkid

Hi all,

I have a worksheet range (say a1:z500) with a lot of values in it, some of these values are errors, like # DIV /0!, # value!, etc...

I want to write a code which replaces all these error values with smth else like "n.a."

I assume this is a basic question, but I'm still at the early stages of learning this stuff..

Many thanks,
-levent

Hi,

Please Login or Register  to view this content.

HTH

exactly what I'm looking for. many thanks..