I have a subroutine that takes a list of names and sees whether or not each one is included in a collection
Being lazy I thought I would do this:-
on error resume next
FoundName = Coll.Item(MyName)
If FoundName="" then ...
The on error is in the loop, but it works once and then fails and I get the VB error.