Transform2 Method

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

The Transform2 method applies a mathematical transform equation to columns. 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.Transform2( Method, RangeMin, RangeMax, Equation, TreatEmptyAsZero )

 

Parameter	Type	Description
Method	wksTransformWith	required; transform on rows, columns, or cells; default is wksTransformWithCol
RangeMin	Variant	required; first row containing values to transform
RangeMax	Variant	required; last row containing values to transform
Equation	String	required; equation written as a string
TreatEmptyAsZero	Boolean	optional; default is false - do not treat empty strings as zero

 

Remarks

See Mathematical Functions for more information on writing the Equation string.

Example

This example shows how to transform cell data by rows.

Wks.Transform2(wksTransformWithRow,1,5,"_5=sum(_1.._4)","False")

 

Used by: Worksheet object