+ Reply to Thread
Results 1 to 5 of 5

Want to know which cells are using a particular Named-List for validation

  1. #1
    Registered User
    Join Date
    03-06-2019
    Location
    San Francisco, USA
    MS-Off Ver
    Microsoft Excel 2003
    Posts
    3

    Post Want to know which cells are using a particular Named-List for validation

    Hi,
    In an excel file I have created a named list by selecting a column and then going to Formulas>DefineName, and, named it MY_LIST.
    Then I have used MY_LIST for validation (as drop-down list) in different cells in more than 1 tabs.

    Now I want to know all the places (cells) where MY_LIST has been used.

    Is there any way to find it out?
    It will help immensely in my project.

    Thanks in Advance!

  2. #2
    Forum Expert
    Join Date
    08-02-2013
    Location
    Québec
    MS-Off Ver
    Excel 2003, 2007, 2013
    Posts
    1,407

    Re: Want to know which cells are using a particular Named-List for validation

    Hi and welcome to the forum

    Here's a suggestion.
    The macro will put in yellow all cells (in all sheets) that match your criteri (ie. validation list with MY_LIST)

    Please Login or Register  to view this content.
    GC Excel - My blog

    If this post helps, then click the star icon (*) in the bottom left-hand corner of my post to Add reputation.

  3. #3
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    15,275

    Re: Want to know which cells are using a particular Named-List for validation

    Hi saby and welcome to the forum,

    To find all the places on a single sheet where Validation is used, you can use the Home Tab > Editing Group > Find and Select dialog > Data Validation. This will select all cells that have data validation. Half of what you want? Also a tool called Power Utility Pack at http://spreadsheetpage.com/index.php/pupv7/home has a tool to list all the validation cells on a sheet (or all sheets) and makes a report.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  4. #4
    Registered User
    Join Date
    03-06-2019
    Location
    San Francisco, USA
    MS-Off Ver
    Microsoft Excel 2003
    Posts
    3

    Re: Want to know which cells are using a particular Named-List for validation

    Thank you so much!! Will install the pupv7 trial version.

  5. #5
    Registered User
    Join Date
    03-06-2019
    Location
    San Francisco, USA
    MS-Off Ver
    Microsoft Excel 2003
    Posts
    3

    Re: Want to know which cells are using a particular Named-List for validation

    Thanks so much! I do not have experience with macros but will blindly run your code and see.. Really appreciate you wrote a code for me!!

+ 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. Data Validation From Named Array List
    By cmore in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-30-2014, 10:14 AM
  2. printing named ranges from a validation list
    By pixifaery in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 08-19-2010, 12:12 PM
  3. Named Range - Data Validation List
    By Tarball in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-28-2010, 12:34 PM
  4. Named formula not seen from validation list source?
    By reggery in forum Excel General
    Replies: 3
    Last Post: 11-12-2009, 08:23 PM
  5. [SOLVED] Changing named Validation list to Dynamic list.
    By GlenC in forum Excel General
    Replies: 1
    Last Post: 07-20-2006, 06:55 PM
  6. Remove empty cells from named list / validation list
    By Sp00k in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-28-2006, 10:45 AM
  7. [SOLVED] Cell value as named range for validation list
    By plantechbl@earthlink.net in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-10-2005, 07:10 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