Apostrophe added during code

I am trying to create an excel file from code within an Access database.

When I use the following line in my code it works but comes out as =Sum('D22':'D35')

.ActiveSheet.Range("D" & x).FormulaR1C1 = "=SUM(D22:D" & x - 1 & ")"

The apostrophes return #NAME? error.

Can somebody help as to what I should be putting in my code?

Thanks in advance

Jonathan

I have worked this out using Row and Column referencing.

Thanks to anybody who had a look into this.

Jonathan