Block If without End If - Darn it!

[JustJim]

I've got a very long sub which imports and verifies data from another database and decides which table in my Db to put it into. There is one very long If xxx Then xxx Else xxx statement and in the Then and the Else there are many With..End Withs and Do..Loops and If..End Ifs. I've been careful with my End Ifs, Loops and End Withs as well as being careful with my indenting but I'm still getting the dreaded Block If without End If when I compile.

The ever helpful compiler highlights the End Sub line when it points out my problem. I've been through it very carefully both on screen and on paper but I still can't find the problem.

The actual question is... is there some sort of parser that will take code and format it, either with colours or with indentations to show where this hated error has occurred?

Thanks in advance for any responses.

Jim

[Rabbit]

I've got a very long sub which imports and verifies data from another database and decides which table in my Db to put it into. There is one very long If xxx Then xxx Else xxx statement and in the Then and the Else there are many With..End Withs and Do..Loops and If..End Ifs. I've been careful with my End Ifs, Loops and End Withs as well as being careful with my indenting but I'm still getting the dreaded Block If without End If when I compile.

The ever helpful compiler highlights the End Sub line when it points out my problem. I've been through it very carefully both on screen and on paper but I still can't find the problem.

The actual question is... is there some sort of parser that will take code and format it, either with colours or with indentations to show where this hated error has occurred?

Thanks in advance for any responses.

Jim

Is there another end sub statement in there? Because that will throw an error. End Sub demarcates the end of the Sub and there can only be one per sub.

[nico5038]

Hi Jim,

In cases like this I often use the elimination trick.
Just save the full code somewhere, remove a large part and execute that part to see or it's OK. Than add more code and continue till the error shows.

Nic;o)

[missinglinq]

It might help if you could post your code using the code tags. I don't know how to display them here without actually having them interpreted as formatting, but before you code place
[ code = vb] and then after the code [ / code ]

When you actually do this, remove all of the spaces from the tags. This will show the various parts of the code in different colors, and might help us (and yourself) in scanning it and spaotting the problem.

Good Luck!

Linq

[JustJim]

It might help if you could post your code using the code tags. I don't know how to display them here without actually having them interpreted as formatting, but before you code place
[ code = vb] and then after the code [ / code ]

When you actually do this, remove all of the spaces from the tags. This will show the various parts of the code in different colors, and might help us (and yourself) in scanning it and spaotting the problem.

Good Luck!

Linq

Thanks for the "Good Luck". It didn't help though. I got in this morning and there had been a "catastrophic server failure" yesterday evening before the daily backup.

I'll start again and hopefully the same mistake won't creep in. It was about 600 lines of code... gone, all gone (sobs).. where did I put that USB stick?

Thanks all for your help. I'l close this thread and if I need more help will start a new one.

Jim