2.54 FAQ-497 How do I use a parameter row or worksheet variable in the Set Column Values dialog?

Last Update: 2/2/2018

You can use the Set Values dialog box to fill one or more worksheet columns with values calculated from a user-defined expression. You can incorporate worksheet header row data in your user-defined expression but you must first declare a variable of type double in the Before Formula Scripts panel of Set Values.

double d1 = %(col(A)[C]\$);

Once defined, you can then use the variable directly in the column formula panel, as in this example expression:

A/d1;//or col(A)/d1 in older versions

For guidance on the syntax used to access worksheet header row data, please see Column Label Row Characters.

See these related topics:

Keywords:set column values, values, formula, column formula, variable, column label row, worksheet header, parameter