Error 7

  • Thread starter Thread starter Ulf Nilsson
  • Start date Start date
U

Ulf Nilsson

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
 
Hi
I'd suggest you change your current VLOOKUP formula. use
something like
=IF(ISNA(VLOOKUP(...)),0,VLOOKUP(..))
 
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(..))

.
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA userform Vlookup Excel 1
copy rows with values - not formulas 1
Formula to VBA 5
OnError not trapping subsequent errors? 4
Hidden sheet bleeds through 3
Runtime error 1004 when trying to insert formula in cells 11
Error when no records meet criteria - repost 3
Error message 1004 2

Back
Top