End if and While End Loops

I am trying to do a number of if then loops whilst inside a while wend loop. I am getting the error . Compile error WEND without While. I have these but obvisouly in my loops it is not rght. I have attached the sheet so you can see what it is doing.

Thanks for your help

hi, luffield, it looks you are missing End If statement:

Please Login or Register  to view this content.

Thanks ever such a lot.

Watersev that works brill, however the last condition code is missing. Any idea's on what else I have got wrong ?

Thanks again

what do you mean by the last condition code is missing? I copied-pasted all the code in the file plus added End if, didn't I?

You did . No I think it is my code that is wrong.

Basically if you run the sheet and look at LG3 Summary the last line has no condition entered in the box on the summary despite it being there on the LG3 tab.

Sorry to be a pain...

try sort of this:

Please Login or Register  to view this content.