Continue to Next Line

[AthmanArumugam]

Hi All,

My array has a huge list of items. I would like to concatenate each line.
I am searching for a proper syntax which I did not get. Can you kindly help me here.
My array list is:

FlatNo = Array("All", "101", "102", "103", "104", "105", "106", "107",)&_ "108", "109","110", "201", "202", "203")&_
"204","

 

[Chihiro]

Something like below.

Sub Test()
FlatNo = Array("All", "101", "103", "104", "105", "106", "107", _
            "108", "109", "110", "201", "202", "203", _
            "204")
End Sub

Edit: Read link for more details.
https://msdn.microsoft.com/en-us/library/ba9sxbw4.aspx

 

[AthmanArumugam]

Hi,
The above solution is not working. I am getting compile error.
Find attached the screenshot.

 

[Marc L]

Hi !

No compilation error on my side wth Chihiro's code ! …
​

 

[AthmanArumugam]

Why I am getting the error. Can anyone guide me. I have to create such an error with items till 10001. Hence I want it to be multiple rows, but unable to concatenate it though.

 

[Chihiro]

There's limit to how many line continuation you can use for single variable.
The limit I believe is 25.

Just create a list of values in worksheet and load to array (or fill array using logic).

 

[Marc L]

Hi !

Better way is like Chihiro in previous post via a worksheet.

But if you do not want data on worksheet, use a String variable
to load data and Split VBA function to create an array :​

     Dim S As String, FlatNo() As String

         S = "All 101 103 104 105 106 107 " & _
             "108 109 110 201 202 203"
       
         S = S & "204 205 " & _
                 "307 308"
   
    FlatNo = Split(S)

Do you like it ? So thanks to click on bottom right Like !

Can be done using only a single Variant variable …
​