Transform - Automation

The Transform method is superseded by Transform3. Please consider using the more recent version. Transform has been retained for backward compatibility.

Transform applies a mathematical transform equation to a column. Returns a Boolean. Returns 'True' if the process is successful, else returns 'False'.

Use Transform3 to apply a mathematical transform equation to columns, rows, or cells and consider empty, numeric, and text cells.

Syntax

object.Transform( FirstRow, LastRow, Equation )

Parameter	Type	Required/ Optional	Default	Description
FirstRow	Long	Required		This specifies the first row containing values to transform.
LastRow	Long	Required		This specifies the last row containing values to transform
Equation	Long	Required		This specifies the 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