"Andrew" wrote in message
...
On Nov 5, 7:50 am, "Clif McIrvin" wrote:
"Clif McIrvin" wrote in message

...



"Andrew" wrote in message
...
Hello,
I'm trying to figure out how to put a single command onto several
lines. This is necessary when the line of code is much wider than
the
editing screen. I see in examples that people use _ to separate
lines
of code. When I try this my code turns red and VBA tells me I have
an
error. Can someone please explain how this is done.

thanks,
Andy

you need a space before the _

from the VBA help glossary:
<quote
line-continuation character
The combination of a space followed by an underscore ( _) used in the
development environment to extend a single logical line of code to two
or more physical lines. However, you can't use a line-continuation
character to continue a line of code within a string
expression.</quote

If the preceeding space wasn't you problem, did you enter a <cr after
the underscore?

From the VBE window, press F1 for help and search for line
continuation
for more information.

--
Clif McIrvin

(clare reads his mail with moe, nomail finds the bit bucket :-)

Thanks for the tip. I was trying to break a string. That explains
it.
...........
You can break a string by using the & concatenation operator:

strLongValue = "First part of a very long string" & _
"second part of a very long string"

Glad you got it sorted!


--
Clif McIrvin

(clare reads his mail with moe, nomail feeds the bit bucket :-)