ON error fetches only first occurance

Hi,

in the below small script the "Vlookup" function throws an error message in case no matching value is found. This is correct and expected and should be handled by the "on Error".
But it works only on the first run.
On the second time the "On Error" does not fetch the problem anymore and the code breaks with error 1004 "Unable to get Vlookup property of worksheetfunction class"

Any idea what I need to do to make the "on Error" statement work every time?
I tried "Err.Clear" to start with a "blank sheet" on every new loop, but that did not change anything.

Please Login or Register  to view this content.

Thanks a lot for any hint - or maybe completely different solution to handle the failing vlookup.

regards Ralf

You need to resume to clear the error

Please Login or Register  to view this content.

Two relevant answers both including working solutions. Thanks a lot!