SetFormula Method (Worksheet)
Sets the formula text for the cell of the specified cell range.
'Declaration
Public Function SetFormula( _
ByVal As Integer, _
ByVal column As Integer, _
ByVal As Integer, _
ByVal column2 As Integer, _
ByVal As String, _
Optional ByVal As Boolean, _
Optional ByVal As Boolean _
) As ActionResult(Of Object)
'Usage
Dim instance As Worksheet
Dim row As Integer
Dim column As Integer
Dim row2 As Integer
Dim column2 As Integer
Dim formula As String
Dim autoFormatting As Boolean
Dim notify As Boolean
Dim value As ActionResult(Of Object)
value = instance.SetFormula(row, column, row2, column2, formula, autoFormatting, notify)
Parameters
- row
- An integer value indicates the top row index of cell range.
- column
- An integer value indicates the left column index of cell range.
- row2
- An integer value indicates the bottom row index of cell range.
- column2
- An integer value indicates the right column index of cell range.
- formula
- A string value indicates the formula text to set
- autoFormatting
- A boolean value indicates that the cell may be auto formatted by some special functions.
- notify
- if set to
true
, the change will be notified.
Return Value
The details data of the action result.