Tutorial by Examples | RIP Tutorial

Use the String function to assign a string with n repeated characters

Dim lineOfHyphens As String 'Assign a string with 80 repeated hyphens lineOfHyphens = String$(80, "-")

VBA • Assigning strings with repeated characters

Use the String and Space functions to assign an n-character string

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, " ")

VBA • Assigning strings with repeated characters