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?