continue line of code in VBA

[farrukh]

Hi All,

how to continue the line of vba code into next line ?
after Allocation6 i want put Allocation7 but continue into next line ?

strHeader = Split("Allocation1,Allocation2,Allocation3,Allocation4,Allocation5,Allocation6, ",")

[Vidya Palani]

You need to use uderscore at the end of first line and beginning of the second line.

Allocation6 _
_ Allocation7")

[xlnitwit]

Hi,

You only need one underscore - at the end of the first line - but you also require an ampersand since you may not put a line continuation in the middle of some text:

Please Login or Register  to view this content.

[farrukh]

strHeader = Split("Allocation1,Allocation2,Allocation3,Allocation4,Allocation5,Allocation6 _
_Allocation7", ",")

invalid character

[farrukh]

xlnitwit thank a lot ...