Yes, that is a good start. However, I will need to modify more than
just one column. Do I have to have a "Range" variable for each column,
or can the range span multiple columns (say, A-H)? And if the range is
multi-column, how do I refer to specific cells in the selected row?

Thank you very much for the clear example, it is very helpful.

Peter