I know that it is possible to Name a formula, such that placing that Name in
a given location will cause that formula to run relative to that cell.
Obviously, this is nice if one wishes to use the same formula throughout a
workbook/worksheet, while retaining the ability to change the formula in only
one place, while having that change apply throughout the workbook/worksheet.

My problem is that the formula that I will be using is both long and
complex. Thus, I want to be able to debug the formula in a cell, then
(rather than re-typing the formula into the "Refers to" portion of the Name
dialog) just reference that "debugged cell" in the "Refers to" section of the
Naming Dialog.

Can this be done? Alternatively, is there a way to copy the formula into
the "Refers to" area, rather than re-typing the whole thing? I've not been
able to successfully copy anything into that area.