Excel VBA array length exceed a line and throwing error

Question

I have declared following variable in excel VBA

>  Dim arrayCollabName as variant 
>  arrayCollabName = Array("Name1","Name2", ....."Name62")

But the Names inside the array are exceeding 1 line in VBA sheet and throwing error

Any suggestion on how to do this without error

Do you mean the VBA editor has tried wrapping some of the names in the array onto the next line of code? If so, try adding an underscore to the end of the previous lines. That's the line-continuation character in VBA... — Rob I
– Rob I, Commented Apr 26, 2012 at 13:51

SwiftMango · Accepted Answer · 2012-04-26 13:50:47Z

3

arrayCollabName = Array("Name1","Name2",..., _
"Name N","Name n+1",...,_
...)

Underscore is the trick to seperate lines.

answered Apr 26, 2012 at 13:50

SwiftMango

15.4k14 gold badges79 silver badges140 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1