Thread
:
Named Range Cells vs. Absolute Cell Addresses
View Single Post
#
2
Posted to microsoft.public.excel.programming
Don Guillett[_4_]
external usenet poster
Posts: 2,337
Named Range Cells vs. Absolute Cell Addresses
Does this help?
Sub ReplaceName()
Cells.Replace What:="badname", _
Replacement:="$G$4", LookAt:=xlPart
End Sub
--
Don Guillett
SalesAid Software
"Mike Short" wrote in message
...
I have a workbook with many cells with names. Throughout
the workbook the references to these cells are made via
the "name".
I want to covert all of these references to the physical
cell address vs. the name. Are there any clever ways to
do this other than one by one?
I have a worksheet that contains all the named cells in
the workbook and their physical address. I tried writing a
macro that did a find and replace. The find worked but the
replace did not. It does work manually.. but there are too
many to convert manually.
Also, are there any utilities that will provide a list of
all cells dependent upon a given cell.
Reply With Quote
Don Guillett[_4_]
View Public Profile
Find all posts by Don Guillett[_4_]