Sets the formula of the worksheet to the given Add-In Formula.

public void SetAddInFormula(string formula)

Public Sub SetAddInFormula(ByVal formula As String)

Add-In Formula you wish to add, as a String. Include the equals sign as well as a reference to the Excel Add-In file you wish to reference, if the file is not included in the local macros directory.

//--- Set Cell D3 on the first Worksheet to reference formula Module1.Apple
//--- from the file TestAddInFormula2Helper.xpl.xla
WB[0]["D3"].SetAddInFormula("=TestAddInFormula2Helper.xpl.xla!Module1.Apple(1)");

'--- Set Cell D3 on the first Worksheet to reference formula Module1.Apple
'--- from the file TestAddInFormula2Helper.xpl.xla
WB(0)("D3").SetAddInFormula("=TestAddInFormula2Helper.xpl.xla!Module1.Apple(1)")