Nested IF Statement not working

[Mphy]

Hi, I have written what I thought was a fairly simple nested IF statement that is not working and I can't work out why. When I try to run it, I get an "Else without If" error message. If I comment out the nested "End If"'s (eg line 13) then it executes but not as intended - if that first If statement evaluates as "N", the code goes to the first nested ElseIf (line 5) rather than the unnested ElseIf (line 14). There is probably something really obvious but I can't see it!

Please Login or Register  to view this content.

[TMS]

I'd be inclined to think that all the ElseIfs should be just Ifs.

[Mphy]

Oh, of course I don't want them to be elseif anyway, I want them all to be individual if statements.

Thanks!

[TMS]

You're welcome.



If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

[Mphy]

Done and done!

[TMS]

Thank you