Excel do while statement

Dr Zoidberg · 29 May 2008 at 00:00

I have put together a macro to run on the press of a button, all is working until close to the end,
I have a do while loop set out like this

Do While condition
statements
loop

which is the method i found via google,
there are no () around the condition and no () or {} around the long list of statements as nothing has said they are needed or excel throws an error if i try to put any in to tie things together.

When i try to compile it i get a 'loop without do' error and have no idea why.

Can anyone help?

Thanks

Tomsk · 29 May 2008 at 08:33

Have you tried VBA own help?
just cursor to 'do' in your macro and press F1

Without seeing the code, it will be difficult for anyone to help.

Dr Zoidberg · 29 May 2008 at 17:08

posted edited,

as soon as i hit submit and looked at the post i spotted the problem.

Meeko · 29 May 2008 at 17:26

Try going through your VBA code in 'Step Through' mode (press F8 in the VBA editor) and this should pinpoint exactly where it is failing.

If you want to post the code, I'm happy to take a look.

A[L]C · 30 May 2008 at 00:07

Meeko said:
If you want to post the code, I'm happy to take a look.

Same here