Check if cell is a named range

Hi,

I'd like to check if a cell is in a named range. Catch is, I don't know in advance what the named range will be (these are defined earlier). My function is as follows :

Please Login or Register  to view this content.

Thanks,
amphi

I don't know in advance what the named range will be (these are defined earlier)

I'm assuming this means you don't know the cells the range will cover, but presumably you do know the name of the range. If so, try this. Change "named_range" to whatever the actual name of the range is.

Please Login or Register  to view this content.

Thanks ! Hadn't thought about looping through the names collection !