posting a formula through vba inserts apostrophies

[joerg1004]

I have a simple macro that rewrites a sumproduct formula:

Cells(14, 5).FormulaR1C1 = "=SUMPRODUCT((Database!D4:D10003=B5)*(Database!F4:F10003=B8)*(Database!B4:B10003>=E5)*(Database!B4:B10003<=E8)*(Database!AI4:AI10003))"

In the actual Excel cell it shows up as

=SUMPRODUCT((Database!'D4':'D10003'='B5')*(Database!'F4':'F10003'='B8')*(Database!'B4':'B10003'>='E5')*(Database!'B4':'B10003'<='E8')*(Database!'AI4':'AI10003'))

The cell references show up in single quotation marks.

What am I doing wrong?

[joerg1004]

I found the problem.

I was using .FormulaR1C1 with an A1 style formula.