Space Function

Returns a string consisting of the specified number of spaces.

Space(number)

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

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.

Community Additions

Show: