View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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