The Transform method applies a mathematical transform equation to columns. Returns a Boolean.
Syntax
object.Transform( FirstRow, LastRow, Equation )
Parameter |
Type |
Description |
FirstRow |
Long |
required; first row containing values to transform |
LastRow |
Long |
required; last row containing values to transform |
Equation |
String |
required; equation written as a string |
Remarks
See Mathematical Functions for more information on writing the Equation string.
Example
This example demonstrates how to apply a mathematical transform equation.
Wks.Transform(FirstRow:=1, LastRow:=50, _
Equation:=" C=(pow(A,2)+ pow(B,2))*(sin(8*atan2(A,B)))")
Used by: WksDocument object