SPACE

SPACE(number)

Returns the specified number of spaces (Variant / String).

number

The number of spaces you want in the text string (Variant / Long).

REMARKS

* This function is useful for formatting output and clearing data in fixed-lengths strings.
* If "number" < 0, then a run-time error occurs.
* If "number" cannot be converted into a number, then a run-time error occurs.
* You can use the SPACE$ function to return a String data type instead of a Variant data type.
* The equivalent .NET function is [[Microsoft.VisualBasic.Strings.Space]]
* For the Microsoft documentation refer to learn.microsoft.com

Debug.Print Space(10)                 '= "          "  
Debug.Print Space(-1)                 ' runtime error  
Debug.Print Space("text")             ' runtime error  

Dim sText As String 
sText = " ' " & Space(10) & " ' " 
Debug.Print sText                     '= " '             ' " (with 12 spaces)