Or simply overwrite the cell reference in the Name Box (to the left of the formula in the formula bar).



Excel built in table automation does this too in a different way and the naming, as far as formulas go anyway, carry down an entire table of values.

* Variables go in columns with the names in the headers (top row).
* Home:Styles:Format as table

The formula, once entered, in each cell in the last column will be =[@RFA]+[@RRA].

He is much, much more knowledgeable than I. However, I will say that sometimes, in rare instances, the "novice" can come up with something novel and unique.

Also, this has been my observation from reading numerous blogs on Excel and VBA. I think we all can learn something from this observation.
Sometimes, the novice has a hard time conveying to the expert, in understandable terms to the expert, what the problem is they are encountering. Likewise, sometimes the "expert" has a hard time conveying to the "novice," in terms the novice understands, how to fix the problem. It's all about COMMUNICATION!! I think the "monkey is on the expert's back" to step back and ask himself or herself, "...is what I am writing understandable to someone who may not be as conversant as I am in Excel and/or VBA.

Just a thought. Best week's wishes to all.