Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Removing range names.
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Removing range names.
You probably need to delete the names. Get hold of a copy of NameManager,
http://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) "Laurence Lombard" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Removing range names.
Hi Laurence, Check out this page on John Walkenbach's site: http://www.j-walk.com/ss/pup/pup6/features.htm & search for "unapply names:". I haven't tried actually it but the trial version promises to do what you want. Hth, Rob Brockett NZ Always learning & the best way to learn is to experience... Laurence Lombard Wrote: 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 -- broro183 ------------------------------------------------------------------------ broro183's Profile: http://www.excelforum.com/member.php...o&userid=30068 View this thread: http://www.excelforum.com/showthread...hreadid=517185 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Print range names and how know if have too many? | Excel Worksheet Functions | |||
not delete worksheets from names in a range | Excel Discussion (Misc queries) | |||
Range Names | Excel Worksheet Functions | |||
Deleting Range name's listed in the range address box. | Excel Discussion (Misc queries) | |||
How do I use Range Names listed in a VLookup table in a formula? | Excel Worksheet Functions |