error handling in a collection

[Ken Cowen]

I am looping through a collection and try to trap the error that occurs when the member of the collection does not exist. I can't get my error handling to deal with the situation, it just ignores my direction to go to a line number and crashes.

On Error GoTo 32

If Not IsError(Lwks(str).ProgD) Then

If str does not exist in the collection Lwks, then I expect and error (5) and would like to go to line 32. If it does exist, it works fine but rather than go to line 32 when it errors, it just crashes.

What am I missing?

Thanks

Ken

 

[crazydragon84]

do you need error handler? can you just do If ISerror then goto ?

 

[V_Malkoti]

You need to use On Error GoTo lineLblName or On Error Resume Next statements.

ISERROR function is used to check for error values like #N/A, #VALUE !, #REF !, #DIV/0!, #NUM !, #NAME? or #NULL - usually caused by formulas.

 

[Ken Cowen]

There seems to be something more problematic than usual about this particular error. It ignores my got line number, it just crashes. I have had trouble with trapping this particular error before and I can't remember how I got it to work. There was some sort of trick to it.
thanks
Ken

 

[Norie]

Ken

Can you post the 'real' code?