+ Reply to Thread
Results 1 to 2 of 2

How to quickly see if active cell is part of a named range.

  1. #1
    Registered User
    Join Date
    10-13-2020
    Location
    Sydney Australia
    MS-Off Ver
    2016
    Posts
    4

    How to quickly see if active cell is part of a named range.

    When I click on a cell and if it is named then its name appears in the dropdown Name Box (just above the A1 cell).

    But if I have a named range...
    Name => "Example"
    Refers To => Sheet1!$B$1:$B$4

    when I click on say cell B3 then the dropdown Name Box shows B3.

    How can I quickly see that it's part of the named range "Example"?

  2. #2
    Forum Expert BMV's Avatar
    Join Date
    01-13-2020
    Location
    St-Petersburg, Russia
    MS-Off Ver
    2013-2016
    Posts
    1,329

    Re: How to quickly see if active cell is part of a named range.

    to detect intersect range by formula you can use isref(Range1 Range2) but for me is not clear what you would like. Could you create small example.

+ 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. Replies: 4
    Last Post: 12-30-2015, 11:40 PM
  2. Finding the named ranges that the active cell is a part of
    By HitTheEXCELerator in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-04-2015, 12:35 AM
  3. [SOLVED] determining if cell is part of named range and what that named range is
    By stnkynts in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-16-2014, 07:56 PM
  4. Find max value in named range and put this + 1 in active cell
    By mlun in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-02-2012, 11:55 AM
  5. Check if cell is part of a named range
    By RobynC in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-26-2008, 02:31 PM
  6. Find out what named range a cell is part of
    By pizzett in forum Excel General
    Replies: 1
    Last Post: 07-25-2007, 10:44 AM
  7. [SOLVED] Is the active cell part of a named range
    By Virginia in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-23-2005, 02:07 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