String: how many characters could contain?

[Nelson78]

Hello everybody.

dim code as string

I have a string composed by 1474 characters.


When I define

code = "..........................................."

part of the string - located in the belove row - is red.


I suspect a maximum length for the string variable. Isn't it?

 

[mole999]

partly dependant on the file type / excel version

 

[RoryA]

A variable length String can contain up to 2billion characters roughly, so that is not the issue.

 

[Fluff]

There is a maximum number of characters per line of code.
You will need to split it up like

code = "........................" & _
      "............."

Although if it's all the same character, then there are simpler ways to do it.