Cell Names

[Pinter]

Ive taken over a file with work that has a lot of named cells and cell ranges. Is there any way to delete these names, either individually or collectively, and have their dependents continue to reference them correctly? Thanks in advance.

[lenze]

You may delete the names unde Insert>Names>Define. If you do, however, formulas that use the Names will no longre function. Suggest you do a Find and replace for each name first.

Find RangeName
Replace with $A$1

[philR]

As lenze so rightly says, you will probably need to do a find and replace on the formulas first. I can help you delete all the ranges at once though, with this bit of vb code:

Sub DeleteNamedRanges()
For n = 1 To ActiveWorkbook.Names.Count
ActiveWorkbook.Names(1).Delete
Next n
End Sub

[Mark W.]

May I ask why you want to replace Names with cell references?