"On Error Exit Do" is compile error??

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ed - 15 Nov 2004 13:40 GMT

I created a Do Loop, then made my first statement after Do to be "On Error
Exit Do". But it highlights in red and gives me a compile error: "Expected:
GoTo or Resume". What did I do wrong? How do I do it right?

Ed

Reply to this Message

Jonathan West - 15 Nov 2004 14:37 GMT

>I created a Do Loop, then made my first statement after Do to be "On Error
> Exit Do". But it highlights in red and gives me a compile error:
> "Expected:
> GoTo or Resume". What did I do wrong? How do I do it right?

Hi Ed,

The only forms that the On Error command can follow are as follows

On Error Resume
On Error Resume Next
On Error Goto label

where label is the name of a label elsewere in the routine

You need to do something like this

Do While SomeCondition
On Error Goto dropout
'your code goes here
Loop
dropout:
'more code follows here

Signature

Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup

Reply to this Message

Ed - 15 Nov 2004 15:08 GMT

Thank you. I had remembered seeing the "Exit" (For, Do If) statements used,
but didn't quite remember how. I will do something else then. I appreciate
the help.

Ed

> >I created a Do Loop, then made my first statement after Do to be "On Error
> > Exit Do". But it highlights in red and gives me a compile error:
[quoted text clipped - 19 lines]
> dropout:
> 'more code follows here

Reply to this Message

Rate this thread: