R
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
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