Resolved Question: how to check wether active cell is part of any range?

i have work book where i have given about 50 of names to ranges
now i need a formula to check if selected cell is part of any ranges
i need MACRO as under

if selected cell is part of any range in active sheet or active workbook then
msgbox " selected cell is part of " [name range]
else
msgbox " selected cell is not part of any named range"

i hope the masters of the excel vba will certainly help me out with this

for information let me mention that i am using excel 2003 and excel 2007 both on same computer

i will be greatfull with your help

thank you
[.....sorry that my English lang. is poor .... ]