Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Named Range Question.
I have an amortization template that I downloaded some time ago. It has
numerous named cells and named ranges. Is there any way other than individually converting the named cell(s) to their respective absolute references? Thanks, Glen -- |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Named Range Question.
Other way to achieve what?
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "LuftRider" wrote in message ... I have an amortization template that I downloaded some time ago. It has numerous named cells and named ranges. Is there any way other than individually converting the named cell(s) to their respective absolute references? Thanks, Glen -- |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Named Range Question.
Try this,
Go to: Tools|Options, then check the box "Formulas" under tab "View" That will show cells with defined name formulas. I hope that is what you want. "LuftRider" wrote: I have an amortization template that I downloaded some time ago. It has numerous named cells and named ranges. Is there any way other than individually converting the named cell(s) to their respective absolute references? Thanks, Glen -- |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Named Range Question.
I'd do this against a copy of the file...
Jim Rech posted a nice response at: http://groups.google.com/groups?thre...%40tkmsftngp03 From: Jim Rech ) Subject: Can I "De-Name" Formula Cell References? Newsgroups: microsoft.public.excel.misc, microsoft.public.excel Date: 2001-02-16 13:32:51 PST 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 ==== Be aware that any reference to those names in your code will be broken. LuftRider wrote: I have an amortization template that I downloaded some time ago. It has numerous named cells and named ranges. Is there any way other than individually converting the named cell(s) to their respective absolute references? Thanks, Glen -- -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Referencing a named range based upon Range name entry in cell | Excel Worksheet Functions | |||
Array as a "named range" - formula ok in cells, but error as "named range" | Excel Discussion (Misc queries) | |||
Named Range Question | Excel Worksheet Functions | |||
inserting a named range into new cells based on a named cell | Excel Discussion (Misc queries) | |||
Named range question | Excel Discussion (Misc queries) |