The String function in VBA creates a String, consisting of several repeated characters.



Number (required) – This parameter represents the number of characters in the returned String.

Character (required) – This parameter signifies a character code or a String, representing the character that is to be repeated in the returned String.


This parameter returns a String consisting of several characters. If the Number or Character arguments are Null, the String function returns Null.

Example 1


aaaaaaaaaa aaaaaaaaaa aaaaaaaaaa
VBA String Function

Pin It on Pinterest

Share This