Yes, but you can't break string integrity.

Instead of

s = "abcd _
efgh"

you have to do

s= "abcd" _
& "efgh"

--
Regards,
Tom Ogilvy

"Steph" wrote in message
...
Hi all. I have a long formula in VBA:

ActiveCell.Formula = "=IF(ISBLANK(B" & cellrow & "),"""",IF(D" & cellrow
&
"=""Yes"",LOWER(CONCATENATE(LEFT(B" & cellrow & ",1),RIGHT(B" & cellrow &
",LEN(B" & cellrow & ")-FIND("" "",B" & cellrow &
")))),LOWER(CONCATENATE(LEFT(B" & cellrow & ",1),""."",RIGHT(B" & cellrow
&
",LEN(B" & cellrow & ")-FIND("" "",B" & cellrow & "))))))"


When I try to fo the "space underscore" to wrap the code down to the next
line, I get compile errors. Can I not use the _ to wrap text within a
formula?