Determin in which named range is the activecell

**stojko89** · 01-24-2013, 08:37 AM

Hi,

Is it possible to determin in which named range is the active cell?
I'm tryn to use this somehow:

Please Login or Register  to view this content.

Is this somehow possible?

**OllieB** · 01-24-2013, 08:45 AM

Try

Please Login or Register  to view this content.

**OllieB** · 01-24-2013, 08:49 AM

Or alternatively

Please Login or Register  to view this content.

**stojko89** · 01-24-2013, 09:00 AM

I was so close. But got one little part wrong

But this is how it will do now!

So thanks for the help.

Please Login or Register  to view this content.

Re: Determin in which named range is the activecell