There are times you need to assign a string variable with a specific character repeated a specific number of times. VBA provides two main functions for this purpose:
String/String$
Space/Space$.
Assigning strings with repeated characters Related Examples