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:


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