+ Reply to Thread
Results 1 to 3 of 3

Count how many times / where a defined name is used

  1. #1
    Registered User
    Join Date
    07-29-2013
    Location
    Morgantown, West Virginia, United States
    MS-Off Ver
    Office 2010
    Posts
    3

    Count how many times / where a defined name is used

    Hi all -

    I'm trying to track down some defined names in a spreadsheet that have incorrect references in them. Problem is, I can see that the names are incorrectly referenced, but I want to see the formulas where these names are referenced in order to see what the reference needs to change to in the updated version of this workbook.

    Any ideas? Thanks in advance!

  2. #2
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: Count how many times / where a defined name is used

    "Control + ~" will show all formulas insteads of their resulting values.

    Control F to search the sheet should jump to each formula with it referenced

  3. #3
    Registered User
    Join Date
    07-29-2013
    Location
    Morgantown, West Virginia, United States
    MS-Off Ver
    Office 2010
    Posts
    3

    Re: Count how many times / where a defined name is used

    Ah! Of course! It's Monday....Thanks!

+ 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] Macro to copy a cell range and paste to a new sheet 'n' times where 'n' defined by formula
    By staminaboy in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-26-2013, 11:39 AM
  2. Function that copies single row as many times as defined
    By Lindlof in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-19-2012, 08:50 AM
  3. Copy and Paste a defined number of times...
    By ccxc007 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-15-2012, 02:10 AM
  4. Replies: 1
    Last Post: 07-15-2012, 06:31 AM
  5. Count times between 2 times and 2 dates
    By Jeremy Ellison in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-18-2005, 09:35 PM

Tags for this Thread

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