Microsoft VB for Applciation - XML file Result skip the else statement.

[SierraV]

Hi Guys,

I have this vb code : -

If LineCode <> NextLineCode Then
Call WriteHeaderStart(a)
SequenceNumber = 1
Call WriteSubLine(a)
NextLineCode = Worksheets("Entries").Cells(Itemrow + 1, 1)
Else
SequenceNumber = SequenceNumber + 1
Call WriteSubLine(a)
NextLineCode = Worksheets("Entries").Cells(Itemrow + 1, 1)
End If

If NextLineCode <> LineCode Then
Call WriteHeaderEnd(a)
NextLineCode = ""
End If

Itemrow = Itemrow + 1​

However the XML result doesn't go to the else statement, keeps on repeating the If and calls the WriteHeaderStart(a). Can anyone help?

 

[Agent666]

Provide the code that defines the LineCode variable?

Edit... And the initial value for the NextLineCode variable.