ApplyTo(WorksheetCell) Method

Applies the formula to the specified cell.

Syntax

Visual Basic

'Declaration
 
Public Overloads Sub ApplyTo( _
   ByVal cell As WorksheetCell _
) 

C#

public void ApplyTo( 
   WorksheetCell cell
)

Parameters

cell

The cell to apply the formula to.

Exceptions

Exception	Description
System.ArgumentNullException	cell is null.
System.InvalidOperationException	cell is part of an array formula or data table which is not confined to just the cell.

Remarks

This method, or one of the other ApplyTo overrides must be used to set the value of a cell to a formula.

After this method returns, the WorksheetCell.Formula of the specified cell will return the formula.

Requirements

Target Platforms: Windows 10, Windows 8.1, Windows 8, Windows 7, Windows Server 2012, Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2