VBA Assigning strings with repeated characters Use the String and Space functions to assign an n-character string
Example
Dim stringOfSpaces As String
'Assign a string with 255 repeated spaces using Space$
stringOfSpaces = Space$(255)
'Assign a string with 255 repeated spaces using String$
stringOfSpaces = String$(255, " ")
