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:

Please Login or Register  to view this content.

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.

Hi stnkynts

Something like this

Please Login or Register  to view this content.

You could do something like this

Please Login or Register  to view this content.