Results 1 to 6 of 6

determining if cell is part of named range and what that named range is

Threaded View

stnkynts determining if cell is part... 08-16-2014, 11:34 AM
Vikas_Gautam Re: determining if cell is... 08-16-2014, 11:48 AM
Vikas_Gautam Re: determining if cell is... 08-16-2014, 11:55 AM
jaslake Re: determining if cell is... 08-16-2014, 12:47 PM
mikerickson Re: determining if cell is... 08-16-2014, 01:03 PM
stnkynts Re: determining if cell is... 08-16-2014, 07:56 PM
  1. #1
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    determining if cell is part of named range and what that named range is

    Ok, I got one I can't seem to figure out.

    Let's say you have a named range, Rng1, which consists of cells A1 & A2. In vba how would you report back what, if any, named range the following cells resides:

    Cells(1, 1)
    '  Looking for a way so that this cell reference would identify that it is part of Rng1
    Note: There are multiple named ranges so using intersect is not feasible. Essentially, through code, I will be given a range and I need to determine if that range if part of a named range.

    If this doesn't make sense or you need an example workbook please let me know. Thanks.
    Last edited by stnkynts; 08-16-2014 at 11:36 AM.

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. 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
  3. 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
  4. Determining if a named range exists
    By a in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-05-2006, 09:45 AM
  5. 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