Excel Automation: Adding formulas into cells

[ganj]

I am creating an Excel sheet from a VFP cursor - simple and straighforward. But when it comes to entering formulas in columns, I'm stuck.

How can I enter any kind of formula, including Excel functions in a range of cells? the kind of formula I need to enter is something like: =sum(a2..z2)/$a$1

TIA

 

[skuhlman]

This example puts a formula into cell D929 which is the sum of all cells in the range D4927. You can really put whatever you want into the formula based upon values you've already figured out previously.

oExcel.ActiveSheet.Cells(929,4).Formula = "=SUM(D4927)"