Apostrophe added during code

[JonPugh]

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')

Please Login or Register  to view this content.

The apostrophes return #NAME? error.

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

Thanks in advance

Jonathan

[JonPugh]

I have worked this out using Row and Column referencing.

Thanks to anybody who had a look into this.

Jonathan