Steve,
You are much better off using the Error mthod of the object to detect errors than to use ON ERROR handlers.
If your error method gets an nError = 1426 you can decide how you want to handle the failure.
>Jim Booth has given me a way to check whether the object exists. However thanks for the ON ERROR idea as I was wondering whether I could do something like that for another problem I've been encountering. Thanks for your help.