Code: Select all
TranslateFormulaFromRangeNameWKS(ActiveSheet, "Actual_Suction_Pressure_Known_Override", "Abacus!$B$24")]
For my purposes, If I find myself in the worksheet "Abacus" then I plan on substituting only "$B$24", as my process of eliminating all use of the range name continues.
But now it strikes me that in some/many/most cases I don't necessarily want or need an absolute reference; I'd be better served by substituting just "B24".
By default, Excel2000 seems to assign an absolute cell address to each defined range name.
Excel adjusts the cell reference (assigned to the range name) when I insert or delete cells away from the referenced cell.
It seems to me that when I start using range names, I must lose all sense of whether the original cell reference was relative or absolute, and therefore cannot map correctly back to the user's original intention. I must elect to go with fully-absolute cell references or fully-relative cell-references, and hope for the best.