Table of contents
Collapse the table of content
Expand the table of content

Space Function

office 365 dev account|Last Updated: 6/12/2017
1 Contributor

Returns a Variant ( String ) consisting of the specified number of spaces. SyntaxSpace ( number ) The required numberargument is the number of spaces you want in the string. Remarks 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.

Dim MyString
' Returns a string with 10 spaces.
MyString = Space(10)

' Insert 10 spaces between two strings.
MyString = "Hello" &; Space(10) &; "World"

© 2018 Microsoft