Version

ApplyTo(WorksheetRegion) Method

Applies the formula to the specified region of cells.
Syntax
'Declaration
 
Public Overloads Sub ApplyTo( _
   ByVal region As WorksheetRegion _
) 
public void ApplyTo( 
   WorksheetRegion region
)

Parameters

region
The region of cells to apply the formula to.
Exceptions
ExceptionDescription
System.ArgumentNullExceptionregion is null.
System.InvalidOperationExceptionregion contains an array formula or data table which extends outside the region.
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 all cells in the specified region will return the formula.

Requirements

Target Platforms: Windows 10, Windows 8.1, Windows 8, 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

See Also