Transform - Automation

 

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