A good place to start is Microsoft online help!

http://office.microsoft.com/en-us/ex...CH100648431033


"Sandeep Jangra" wrote:

D'all,
Plz help on "Defien Name" under Insert menu in excel and How can I use
defined names in excel formula. If I have defined two areas for two different
tables in same sheet and both the tables have a same column Lable then how
can I distinguish between them.