Hi Mike

Try this:

Dim MyString
MyString = String(5, "*") ' Returns "*****".

"Mike H." wrote:

In another language I am familiar with if I wanted to express the text
"-----" I could say repeat("-",5). Is there something similar in VBA?