+ Reply to Thread
Results 1 to 1 of 1

Can't apply NAMES to pre-existing formulas

  1. #1
    Registered User
    Join Date
    10-19-2005
    Posts
    48

    Can't apply NAMES to pre-existing formulas

    Hi there,

    I have defined NAMES for some cell ranges.
    These work well when I type in new cell formulas (the range I type in automatically gets replaced by the corresponding NAME), but I can't use the NAME>APPLY to replace cell references in existing formulas. I get the following error message:
    "Microsoft Excel cannot find any references to replace"
    even though the reference is there indeed, and the name is highlighted in the apply box.
    The cell by the way include several ranges BTW.

    What am I doing wrong?
    thx,
    jm

    I forgot to mention: the NAME refer to ranges on another spreadsheet
    Last edited by jmwismer; 11-07-2007 at 12:27 PM.

+ 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