This documentation is archived and is not being maintained.
This page is specific to the Visual Basic for Applications (VBA) Language Reference for Office 2010.
Returns a Variant (String) consisting of the specified number of spaces.
The required number argument is the number of spaces you want in the string.
The Space function is useful for formatting output and clearing data in fixed-length strings.
This example uses the Space function to return a string consisting of a specified number of spaces.
' Returns a string with 10 spaces.
MyString = Space(10)
' Insert 10 spaces between two strings.
MyString = "Hello" & Space(10) & "World"