ExcelBanter - Error 7

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Error 7 (https://www.excelbanter.com/excel-programming/295628-error-7-a.html)

Ulf Nilsson

Error 7

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

Frank Kabel

Error 7

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
.

Ulf Nilsson

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
.

.

All times are GMT +1. The time now is 05:07 PM.