Vba - combine formulas stored as variables

[moni_tm]

Hello,

Please can anyone help. And please forgive any errors in terminology.

I have stored two formulas as variables which I can see are correct on the Locals window. I now want to combine these two formulas together in another cell.
So far I have following but I cant seem to work out how to combine them..

F1 = Range("E1:E1000").Find("FTE's").Offset(1, 1).Formula
F2 = Range("E1:E1000").Find("FTE's").Offset(1, 2).Formula

Range("E1:E1000").Find("FTE's").Offset(0, 1).Formula = "=" & F1 + F2

Can anyone help?!

All help, as always is much appreciated.

Tom

 

[Rick Rothstein]

Hello,

Please can anyone help. And please forgive any errors in terminology.

I have stored two formulas as variables which I can see are correct on the Locals window. I now want to combine these two formulas together in another cell.
So far I have following but I cant seem to work out how to combine them..

F1 = Range("E1:E1000").Find("FTE's").Offset(1, 1).Formula
F2 = Range("E1:E1000").Find("FTE's").Offset(1, 2).Formula

[B][COLOR="#FF0000"]Range("E1:E1000").Find("FTE's").Offset(0, 1).Formula = "=" & F1 + F2[/COLOR][/B]

Can anyone help?!

Untested (as I am about to go to sleep), but see if this works...

Range("E1:E1000").Find("FTE's").Offset(0, 1).Formula = F1 & "+" & Mid(F2, 2)

Both formulas start with an equal sign, so I used the equal sign from F1 to start the combined formula but removed the equal sign from the second formula.

 

[moni_tm]

Thanks Rick, worked a treat.

Tom