View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Per Jessen Per Jessen is offline
external usenet poster
 
Posts: 1,533
Default On Error - Only executing once.

Hi Nate

It's not easy to see what's wrong without the entire code!

Do you set
skip = False
before second loop?

Regards,

Per

"NateBuckley" skrev i meddelelsen
...
Hello I have a On Error Goto statement, yet it only works once, then It
just
ignores and tries to execute although this causes it to crash.

I'm attempting to grab stuff from a collection


Set tmp = lookUpCollection.Item("Monkey"), there is no object with the key
monkey, and it bypasses it on the first go by following my error handling
line

On Error Goto ShouldSkip

The ShouldSkip label contains the following

ShouldSkip:
skip = True
GoTo CheckSkip

Why is it only doing it once, I've used this method before and it worked
fine, just all of a suddent I'm getting the error

Invalid Procedure Call or argument.

Thanks in advance.