Excel do while statement

[Dr Zoidberg]

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

 

[Dr Zoidberg]

posted edited,

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