Syntax

Space(number)

The number argument is the number of spaces you want in the string.

Remarks
The following example uses the Space function to return a string consisting of a specified number of spaces:

Dim MyString
MyString = Space(10) ' Returns a string with 10 spaces.
MyString = "Hello" & Space(10) & "World" ' Insert 10 spaces between two strings.

related to
String