Pascal,

I was hoping to do this as a worksheet function. Either one I have to write
myself or one that already exists. I could not find intersect as one of the
builtin excel functions. Is there some way I can do this in a cell?

For instance:

=IsInRange(B9, Jan)

"papou" wrote:

Hello
Programmatically?
MsgBox IIf(Intersect(Range("B3"), Range("jan")) Is Nothing, False, True)

HTH
Cordially
Pascal

"fedude" a écrit dans le message de news:
...
Is there a way to determine if a single cell is in a named array?

For instance,

In B7, I want to know if B3 is in a range called "Jan"