Passing Variable length Space Characters to Variables
But what if the space width is variable in length?
Just one example:
Sub Demo()
Dim n, Str
n = 10
Str = Space(n)
End Sub
--
HTH. :)
Dana DeLouis
Windows XP, Office 2003
"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
|