Error 7
Thanks!
Just what I was looking for!
/ Ulf
-----Original Message-----
Hi
I'd suggest you change your current VLOOKUP formula. use
something like
=IF(ISNA(VLOOKUP(...)),0,VLOOKUP(..))
-----Original Message-----
Hi,
I want to loop through every worksheet and replace
error
messages (error type 7) with 0. How is this done using
VBA?
I get error type 7 when I use VLOOKUP and the search
value is not found.
/ Ulf
.
.
|