An error handler can not have an error handler in it. As for testing an
object that is do-able...

Dim wks as worksheet

if wks is nothing then msgbox "No sheet"
set wks = sheet1
if wks is nothing then msgbox "Still no sheet"
--
HTH...

Jim Thomlinson


"Jerry" wrote:

Hi guys;

I have On Error GoTo routine in a module.
in the error-handling routine, I have On Error GoTo 0

The first time the error is hit; process goes to "routine", correctly.
The second time, however, process does not jump. Err.number is set.

Why?

Also, is there a way to test for an object containing Nothing ( not
valid reference)?

Thanks;
Jerry