Transform Method

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

The Transform method applies a mathematical transform equation to a column. Returns a Boolean.

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	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.

Set Wks = GrapherApp.Documents.Open(GrapherApp.Path + _

"\samples\sample1.dat")

Wks.Transform(1, 50, "d=(pow(a,2)+pow(a,2))*(sin(8*atan2(a,b)))")

 

Used by: Worksheet object