Setting a Cell's Formula

[Chris Spicer]

Hi,

Is it possible to set the formula of a cell through ExcelDna? By this
I mean through a menu driven macro function, rather than triggerd by a
UDF.

I notice that the C API supports xlset for quickly setting a value to
cell, but this doesn't seem appropriate for formulas.

Regards,

Chris Spicer

[Govert van Drimmelen]

Hi Chris,

You can try something like
XlCall.Excel(XlCall.xlcFormula, "=2+2", theReference)

References in the formula have to be R1C1-style.
Use XlCall.xlcFomulaArray for an array formula.

Hope this helps.

Govert

[Chris Spicer]

Excellent response as always Govert. Thanks for that.