Msgbox Activeworkbook.Names("myName").RefersTo

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Nader" wrote in message
...
Hello,

I have a lot of "NAME" in my excel sheet and sometime when I checked them
thru "INSERTNAMEDEFINE" I can see that some of them have changed by
themself. Is there a way to automatically access them via VBA so I can
make a backup ?

Thanks in advance for the help!

Cheers!