Does this help?

Sub Test()
Dim strData As String
strData = Space(50)
Debug.Print Len(strData)
Debug.Print strData & "x"
End Sub

Robin Hammond
www.enhanceddatasystems.com

"ExcelMonkey" wrote in message
...
How do you pass variable length space to a variable. If I want to pass a
space cwith three spaces, I can do it manually by going:

Var = "---" (dashes representing spaces)

But what if the space width is variable in length? In this example I need
to pass the number three to a variable and then use this to define the
space
between my quotes that get passed to my Var.

Thanks