I am having some problems with this code. This is part of a macro.

This part is working fine
ActiveCell.FormulaR1C1 = "=SUM(RC[" & -Sheets.Count & "]:RC[-2])"
But I want to include this part
-(Cells(11, Sheets.Count + 1))
Thus having
ActiveCell.FormulaR1C1 = "=SUM(RC[" & -Sheets.Count & "]:RC[-2])-" &
(Cells(11, Sheets.Count + 1))
This way it does not work. It gives me an error, and I can understand why.

Another problem is that the result of the following code is:
ActiveCell.FormulaR1C1 = "=SUM(" & Sheets(1).Name & ":" &
Sheets(Sheets.Count).Name & "!e11)"
=SUM(tps1:tps26!e11)
The expression e11 appears between €˜. I need to remove this €˜, but dont
know who.

Any help is most welcome.