Prev: how to disable track change
Next: VBA Code Cleaner
From: Tony No Baloney on 6 May 2010 08:19
I am working on a macro in Word 2007 with VBA. There are few sections
of the code I would like to have
multiple carriage returns (one for seven lines, one for four lines,
etc.).

I am using vbcrlf multiple times (ex. vbCrLf & vbCrLf & vbCrLf &
vbCrLf & vbCrLf ...)

Is there a way to type a shortcut so it looks like this vbCrlf * 6?
From: "Tony Jollans" My forename at my surname dot on 6 May 2010 08:45
You can generate multiple copies of a single character with the String
function, but only single characters and CrLf is two characters. You could
use something like this to overcome that limitation:

Replace(String(3, vbCr), vbCr, vbCrLf)

--
Enjoy,
Tony

www.WordArticles.com

"Tony No Baloney" <tonyrulesyall(a)yahoo.com> wrote in message
news:89368e8b-81ad-4e28-8a31-e816080c3910(a)a21g2000yqn.googlegroups.com...
>I am working on a macro in Word 2007 with VBA. There are few sections
> of the code I would like to have
> multiple carriage returns (one for seven lines, one for four lines,
> etc.).
>
> I am using vbcrlf multiple times (ex. vbCrLf & vbCrLf & vbCrLf &
> vbCrLf & vbCrLf ...)
>
> Is there a way to type a shortcut so it looks like this vbCrlf * 6?

 | 
Pages: 1
Prev: how to disable track change
Next: VBA Code Cleaner