Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Jul 2002
    Posts
    16
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Replacing name reference in formulas (2002)

    Thank in advance for you help on this.

    Is there any way to quickly swap out all of the named ranges in formulas? I can certainly delete the name and then manually go through each formula and replace the reference. This is made problematic since when you delete a named range then the formulas that referred to that range have a REF# error. Maybe there is a utility out there that can do a find and replace?

    Yours,
    Terry Galiney
    Seattle, WA

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Replacing name reference in formulas (2002)

    You can use excel's find and replace to replace a name range with a cell reference.

    If you select only one cell, and then select replace ALL it will do the entire sheet. If you want to do the entire workbook select all the sheets before doing find /replace.

    Steve

Posting Permissions

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