for...next funny behaviour

S

Steve

I have a for next loop in my vba code. First I comment out the for and the
next statements and the code compiles correctly.

If I un-comment the for and leave the next commented out I get a "for
without next" error.

If I either un-comment the next and leave the for commented or un-comment
both the for and the next I get a "next without for" error.
 
T

Tom Hutchins

Check your code for an If...End If construct that encompasses the Next
statement of your For...Next loop. Something like this:

For x = 1 To 10
If Len(y)=0 Then
'do something
Next x
End If

Hope this helps,

Hutch
 
N

Niek Otten

How do you expect any of us to solve this without seeing your code?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I have a for next loop in my vba code. First I comment out the for and the
| next statements and the code compiles correctly.
|
| If I un-comment the for and leave the next commented out I get a "for
| without next" error.
|
| If I either un-comment the next and leave the for commented or un-comment
| both the for and the next I get a "next without for" error.
|
|
 
N

Niek Otten

I had no intention to offend you.

Of course we can start guessing.
Surrounding For/Nexts? Overlooked or missing continuation symbol? Old Excel VBA in a localized language? etc.

Why not give us just as much information as you gave to the compiler, which refused the code?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


| What a snot.
|
| "Niek Otten" wrote:
|
| > How do you expect any of us to solve this without seeing your code?
| >
| > --
| > Kind regards,
| >
| > Niek Otten
| > Microsoft MVP - Excel
| >
| > |I have a for next loop in my vba code. First I comment out the for and the
| > | next statements and the code compiles correctly.
| > |
| > | If I un-comment the for and leave the next commented out I get a "for
| > | without next" error.
| > |
| > | If I either un-comment the next and leave the for commented or un-comment
| > | both the for and the next I get a "next without for" error.
| > |
| > |
| >
| >
| >
 
Top