Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Callum Smith   on Sep 02 In MS Office Category.

  
Question Answered By: Kristen Chavez   on Sep 02

This is speculation, but ...

The "on error" fires and you jump to the "notfound" label. At this point,
you are in "error handler" mode. You then loop  and potentially have another
error. But you're already in error  mode, so a further error will not cause
the jump.

You could try putting an "on error goto 0" in the "notfound" code. That
might fix things.

Otherwise, you might need to exit from the loop and/or the sub to clear
error mode.

Speculation only - I could easily be completely off track.

Share: 

 

This Question has 3 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on compare data in two sheets Or get search suggestion and latest updates.


Tagged: