How do I use a parameter row or worksheet variable in the Set Column Values dialog


In the Set Column Values dialog, you need to use the Before Formula Scripts panel to assign the value of the parameter row to a double.

double dd = %(col(a)[P1]$);

the formula could then be:

col(a)/dd;
Image:Set_Col_Val_with_wks_paramater.png

To access other worksheet headers, please read the Column Label Row Characters