+ Reply to Thread
Results 1 to 2 of 2

How to rename references from range names to cell references

  1. #1
    Abbas
    Guest

    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. #2
    Bob Phillips
    Guest

    Re: 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" <Abbas@discussions.microsoft.com> wrote in message
    news:CA8507C0-2045-4B80-91EF-2D08D1627601@microsoft.com...
    > 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 to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1