Hi.. I know this is a "rookie" question so let me apologize to the forum
ahead of time.

However...

I am trying to include a Try block in to my code. However, there seems to
be no reference to whatever object holds this code as it does not understand
when I try to say something like this
Try

.....

END Try
I know I need to go in to "Tools-Reference" to add the correct module but
I have have no idea which object needs to be added. Can anyone help?
Also, is there a reference guide somewhere that tells you what "library" a
command is in?

Again, thanks in advance and for helping me out.

There is no Try/Catch construct in VBA.

For error trapping, see the On Error statement in VBA Help

Does that help?
***********
Regards,
Ron

XL2003, WinXP


"hll" wrote:

Hi.. I know this is a "rookie" question so let me apologize to the forum
ahead of time.

However...

I am trying to include a Try block in to my code. However, there seems to
be no reference to whatever object holds this code as it does not understand
when I try to say something like this
Try

....

END Try
I know I need to go in to "Tools-Reference" to add the correct module but
I have have no idea which object needs to be added. Can anyone help?
Also, is there a reference guide somewhere that tells you what "library" a
command is in?

Again, thanks in advance and for helping me out.