Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 24th 06, 05:09 PM posted to microsoft.public.excel.misc
Abbas
 
Posts: n/a
Default How to rename references from range names to cell references

I am working with files with defined range names. These name ranges refer to
on cell only. I want to change all formulae in the file: change range name
back to cell reference (so I can delete the range names).

E.g. cell $A$42 is called range "ip_con" - there is a formula in cell b99
that says "=ip_con +200". I want the formula to say "=$A$42+200".
Obviously, there are a lot of these references, so looking them by manually
is NOT an option.

Any help would be appreciated!!!!

  #2   Report Post  
Old May 24th 06, 06:18 PM posted to microsoft.public.excel.misc
Bob Phillips
 
Posts: n/a
Default How to rename references from range names to cell references

I don't know that it does do that, but it sounds the sort of thing that Jan
Karel Pieterse' NameManager addin
http://www.jkp-ads.com/OfficeMarketPlaceNM-EN.asp does. Give it a try.

--
HTH

Bob Phillips

(replace xxxx in email address with googlemail if mailing direct)

"Abbas" wrote in message
...
I am working with files with defined range names. These name ranges refer

to
on cell only. I want to change all formulae in the file: change range

name
back to cell reference (so I can delete the range names).

E.g. cell $A$42 is called range "ip_con" - there is a formula in cell b99
that says "=ip_con +200". I want the formula to say "=$A$42+200".
Obviously, there are a lot of these references, so looking them by

manually
is NOT an option.

Any help would be appreciated!!!!





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Changing cell references in formulas to names and back again. Aaron Excel Discussion (Misc queries) 4 April 25th 06 11:12 PM
Cell Reference with Range Name SCSC Excel Worksheet Functions 2 March 23rd 06 11:32 PM
Row Expansion Susan Excel Worksheet Functions 11 February 28th 06 07:15 PM
Adding a row to worksheet does not update cell references in another. blausen Excel Worksheet Functions 5 February 25th 06 09:14 PM
Possible Lookup Table Karen Excel Worksheet Functions 5 June 8th 05 09:43 PM


All times are GMT +1. The time now is 06:16 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017