Hello NG,

Can some one please tell me how to trap a specific error?

I want to be able to test for a couple of different errors by the error
number and then handle the error a specific way.

Any help would be greatly appreciated

Thanks
James

In VBA help, do a search for the Err object. That will give you a start.
Under 'See Also', there might be a link to a list of "Trappable Errors"

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"James Agostinho" wrote in message
...
Hello NG,

Can some one please tell me how to trap a specific error?

I want to be able to test for a couple of different errors by the error
number and then handle the error a specific way.

Any help would be greatly appreciated

Thanks
James