software

I have created a number of formulas that refer to named cells instead of the
cell references. I used the facility Insert/names/apply. I now want to
reverse this Apply process (automatically)- in other words use the cell
references instead of the names. How do I do this.

The problem is I want to copy the formulas for example
If A1 is named LENGTH and B1 contains the formula =5*LENGTH I want to change
it back to =5*A1 so that I can copy B1 to B1:B10 so that B2 would have the
formula =5*A2 and not =5*LENGTH (which refers to A1).

I am having difficulty explaining myself. I hope somebody can follow.
Laurence
You probably need to delete the names. Get hold of a copy of NameManager,
www.jkp-ads.com/OfficeMarketPlaceNM-EN.asp , I don't know that it
will solve this, but it makes working with names a lot simpler.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Laurence Lombardquot; gt; wrote in message
...
gt; I have created a number of formulas that refer to named cells instead of
the
gt; cell references. I used the facility Insert/names/apply. I now want to
gt; reverse this Apply process (automatically)- in other words use the cell
gt; references instead of the names. How do I do this.
gt;
gt; The problem is I want to copy the formulas for example
gt; If A1 is named LENGTH and B1 contains the formula =5*LENGTH I want to
change
gt; it back to =5*A1 so that I can copy B1 to B1:B10 so that B2 would have the
gt; formula =5*A2 and not =5*LENGTH (which refers to A1).
gt;
gt; I am having difficulty explaining myself. I hope somebody can follow.
gt; Laurence
gt;
gt;

Hi Laurence,

Check out this page on John Walkenbach's site:
www.j-walk.com/ss/pup/pup6/features.htm
amp; search for quot;unapply names:quot;. I haven't tried actually it but the
trial version promises to do what you want.

Hth,
Rob Brockett
NZ
Always learning amp; the best way to learn is to experience...Laurence Lombard Wrote:
gt; I have created a number of formulas that refer to named cells instead of
gt; the
gt; cell references. I used the facility Insert/names/apply. I now want to
gt; reverse this Apply process (automatically)- in other words use the
gt; cell
gt; references instead of the names. How do I do this.
gt;
gt; The problem is I want to copy the formulas for example
gt; If A1 is named LENGTH and B1 contains the formula =5*LENGTH I want to
gt; change
gt; it back to =5*A1 so that I can copy B1 to B1:B10 so that B2 would have
gt; the
gt; formula =5*A2 and not =5*LENGTH (which refers to A1).
gt;
gt; I am having difficulty explaining myself. I hope somebody can follow.
gt; Laurence--
broro183
------------------------------------------------------------------------
broro183's Profile: www.excelforum.com/member.php...oamp;userid=30068
View this thread: www.excelforum.com/showthread...hreadid=517185