Repeat Character in VBA
Just to add to Jim's reply...
There's another function that can be used with other non-space characters:
dim str as string
str = String(12, "x")
(It can also be used with space characters <bg.)
Jim Thomlinson wrote:
There is a function called space that you could use
dim str as string
str = "this" & space(10) & "that"
--
HTH...
Jim Thomlinson
"Brad" wrote:
Thanks for taking the time to read my question
I would like add a space to my string x times, where x = an integer.
How can I do that with out using a loop statement?
x=10
eg: "there are 10 spaces between here" & space * x & "here."
Thanks,
Brad
--
Dave Peterson
|