How to repeat a character?

  • Thread starter Thread starter wdsnews
  • Start date Start date
W

wdsnews

First, is there a syntax book I can buy similar to the syntax manuals we
used to get with programming languages? I'm new to VBA. I'd appreciate
your suggestion on a book that is more reference and less tutorial. (BTW,
I've found a couple of tutorial books I really like. So now I need a
reference.)

Is there a function that repeats a specific character a given number of
times similar to the way the Space(x) function repeats the space character a
given number of times?

thanks for your help.
 
First, is there a syntax book I can buy similar to the syntax manuals we
used to get with programming languages? I'm new to VBA. I'd appreciate
your suggestion on a book that is more reference and less tutorial. (BTW,
I've found a couple of tutorial books I really like. So now I need a
reference.)

Is there a function that repeats a specific character a given number of
times similar to the way the Space(x) function repeats the space character a
given number of times?

thanks for your help.
Click to expand...

Look up the String() function in VBA Help.

=String(10,"X")
will return "XXXXXXXXXX"
 
Back
Top