replace ranges with names existing formulas

[Steve Mackay]

Simple question, I am sure...

How can replace references in my formulas with named ranges (besides doing a
Find..Replace)? For instance, if I have references in a bunch of formulas
to A1:C10 and later name that range "Table1," is there a way to
automatically change all of the references in the formulas to say "Table1."

What about doing it in reverse (ie names to references).

Thanks,

 

[Dana DeLouis]

Select your range of cells, and do...
Insert | Name | Apply..

and select the names that you want to apply to your selection.

HTH
Dana DeLouis

 

[Steve Mackay]

Ah...I knew it was easy. Thanks! What about the reverse...changing names
to references?

--
--
Steve Mackay

Select your range of cells, and do...
Insert | Name | Apply..

and select the names that you want to apply to your selection.

HTH
Dana DeLouis

 

[Myrna Larson]

That's no so easy. John Walkenbach's Power Utilty Pack has a feature to do
this, but the last time I tried it, it didn't replace all names, and neither
he nor I could figure out why.