How to repeat a character?

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.
 
F

fredg

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"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Is there a way to stop repeating a character when a key is held do 1
Access Macro Repeat Expression using value of a field in table 0
Counting Specific Character(s) In A Range? 10
Counting a Specific Character 2
How to repeat a sound file 2
Repeat macro until record count of query = 0 0
Finding/counting a given character within a cell 10
find the last occurance of a character in a cell 5

Top