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