Proper way to write a string?

[g48dd]

Excel 2003: I am not sure if you call it a string or an array or if they are one and the same but I have code that has many mmmm I think you call them elements?

"A12,A16,A35,A38,A69,A72,A103,A106,A137,A140,A172,A175,A207,A210,A242,A245,A277,A280,A311,A314,A346,A349,A381,A384,A416,A425,A453,A456,A488,A491,A532,A526,A558,A561,A593,A596,A628,A631,A663,A667,A686,A690,A709,A713,A732,A756,A759,A791,A794,A826,A830"

If I use the ENTER KEY to make this wrap in the CODE WINDOW. Look above you can see my string is all in one big long string lol OK well that is hard to work with. So I placed my curser at the end of one the commas and hit ENTER to wrap the string, but I get an error message that is telling me that I need to enclose my argument with parentheses even though it is, it is just that the line is broken with ENTER /RETURN KEY. How do I work around this.

 

[John_w]

To write a long string over several code lines, you need to divide it into separate strings enclosed by double quotes, concatenate them and use the line continuation character, like this:

    Dim s As String
    
    s = "A12,A16,A35,A38,A69,A72,A103,A106,A137,A140,A172,A175,A207," & _
        "A210,A242,A245,A277,A280,A311,A314,A346,A349,A381,A384,A416," & _
        "A425,A453,A456,A488,A491,A532,A526,A558,A561,A593,A596,A628," & _
        "A631,A663,A667,A686,A690,A709,A713,A732,A756,A759,A791,A794,A826,A830"

 

[g48dd]

Thank you, rather than copy what you wrote I typed it in myself, hopefully that will help me remember.

Ken