Excel 2007 : Compile Error: Block if without end if, when I add a end if it says end if without...

[F1lm1]

Block if.
It stinks. I had this problem for days now, and when someone adds a suggestion it does not work. If you can, please hurry, I'm operating on a deadline...

Please Login or Register  to view this content.

When I add the end if like a suggestion said, I get

Please Login or Register  to view this content.

I get end if without block if problem. Please help, anyone.

BTW, the point of this macro is to display all the info in an xml file into one sheet. Please tell me if I am doing anything else wrong.
Thank you

[shg]

Please Login or Register  to view this content.

See the problem?

[F1lm1]

Code:

If nde1.HasChildNodes Then
For Each nde2 In nde1.ChildNodes
'Set nde3 = nde2.parentNode
End If
Next

See the problem?

TBH, not really.

[shg]

What line does the End If pair with?

What line does the Next pair with?

[F1lm1]

At the risk of sounding stupid, what does next pair with?

[shg]

The Next goes with the For Each, the End If goes with the If. They have to be nested in pairs; they are in the wrong order.

I was assuming that you had written this code.

[F1lm1]

Ok. I will try.
BTW, yes I wrote it

[F1lm1]

Alright. Okay, I rearranged them, and it seemed to work, but I got a problem on a different topic (in excel).
My code currently is

Please Login or Register  to view this content.

And it said object variable or with block variable not set. Any ideas?

[shg]

Can't help with that one, other than observing that you never initialized nde1, but please start a new thread for the new topic.