+ Reply to Thread
Results 1 to 6 of 6

Help fixing #REF in named ranges

  1. #1
    Forum Contributor
    Join Date
    02-16-2008
    Location
    Mansfield, TX
    Posts
    324

    Help fixing #REF in named ranges

    Hello, I have about 100 named ranges that I need to find and replace the #REF with DATA in. Example named range is below.

    =#REF!$H$2:INDEX(#REF!$H:$H,Datalrow)

    Does anyone have any idea how to do this?

  2. #2
    Forum Expert
    Join Date
    06-25-2009
    Location
    Sofia, Bulgaria, EU
    MS-Off Ver
    Excel 2003-2013
    Posts
    1,290

    Re: Help fixing #REF in named ranges

    Hi,
    try this

    Please Login or Register  to view this content.
    If you are pleased with a member's answer then use the Star icon to rate it.

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,926

    Re: Help fixing #REF in named ranges

    Not sure if this will work, but you can try using the build-in Find/Replace (which is pretty much what buran has, but you dont need VBA for this)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  4. #4
    Forum Expert
    Join Date
    06-25-2009
    Location
    Sofia, Bulgaria, EU
    MS-Off Ver
    Excel 2003-2013
    Posts
    1,290

    Re: Help fixing #REF in named ranges

    @FDibbins: Is it possible to search/replace in the names using the build in dialog?

  5. #5
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,926

    Re: Help fixing #REF in named ranges

    Quote Originally Posted by buran View Post
    @FDibbins: Is it possible to search/replace in the names using the build in dialog?
    Not sure what you mean by that? Highlight the range in question, press CTRL H and that will take you to the Find/Replace window

  6. #6
    Forum Expert
    Join Date
    06-25-2009
    Location
    Sofia, Bulgaria, EU
    MS-Off Ver
    Excel 2003-2013
    Posts
    1,290

    Re: Help fixing #REF in named ranges

    Quote Originally Posted by FDibbins View Post
    Not sure what you mean by that? Highlight the range in question, press CTRL H and that will take you to the Find/Replace window
    Of course I know how to display Find/Replace window :-)
    Maybe I have wrong understanding of the dcgrove's problem. My understanding is that there are about 100 "named ranges", i.e. names and he/she needs to edit RefersTo property of the name. This is not possible with Find/Replace Window. The alternatives are to edit each name individually in the Name Manager or use VBA. Anyway, there is no feedback from dcgrove...

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Determining if the value of a cell can be a named range, then assigning named ranges after
    By Romulo in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-15-2013, 06:05 PM
  2. Replies: 0
    Last Post: 10-15-2012, 07:24 AM
  3. fixing cell/ formula ranges
    By luke_p in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-17-2009, 09:51 AM
  4. Copy data in named ranges to a newer version of the same template to identical ranges
    By handstand in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-21-2006, 10:51 AM
  5. Replies: 1
    Last Post: 03-21-2006, 06:40 PM

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