Formula on two or more lines

[Rob]

Hi,

I am using a mcro to place a formula into a cell and whilst the example
below isn't too long, I would like to have this over a couple of lines. I
have tried placing a space and an underscore in the formula as a line break
but the formula errors.

Do formulas need to be on a single line?

..Formula = _
"=TRIM(MID(VLOOKUP(""H0""&LEFT(A1,3),'[" & IName &
"]Sites'!Data,2,False),9,50))"

Thanks, Rob