Can I "De-Name" Formula Cell References?

[jackosullivan]

(sorry if this is a duplicate ... some confusion with my new nntp server)
In Excel 97, is there any way to get formula references back to the A1 style
from the "names" imposed on them by Insert|Name|Apply?

Alternatively -- perhaps even better -- is there any way to force some of
those names to become "relative references" once the .Apply has imposed
"absolute"-ness on them?

Thanks very much and God bless!
Jack O'Sullivan

[Jim Rech]

To do it to a cell or two first turn on Transition Formula Entry under
Tools, Options, Transition. Then go to the cell and press F2 and Enter.
When you turn off TFE the formula references should be de-named.

If you have a lot of cells to de-name select the range and run this macro:

Sub Dename()
Dim Cell As Range
ActiveSheet.TransitionFormEntry = True
For Each Cell In Selection.SpecialCells(xlFormulas)
Cell.Formula = Cell.Formula
Next
ActiveSheet.TransitionFormEntry = False
End Sub

--
Jim Rech
Excel MVP

[jackosullivan]

WOW! that's got to be world-record service! Thanks ever so much, John and
Jim!
God bless!

"jackosullivan" <osul...@compuserve.com> wrote in message
news:wkgj6.23$446....@nnrp2.sbc.net...