Re: $$Excel-Macros$$ Name Manager

2012-05-12 Thread dguillett1
Homework? Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: vijayajith VA Sent: Saturday, May 12, 2012 12:05 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Name Manager Hi, I want to know about Name Manager.. .. what is the use of Name manager.

Re: $$Excel-Macros$$ Name Manager

2012-05-12 Thread ╰» ℓαℓιт мσαнη
Hi, By using names, you can make your formulas much easier to understand and maintain. You can define a name for a cell range, function, constant, or table. Once you adopt the practice of using names in your workbook, you can easily update, audit, and manage these names. Regards, Lalit Mohan ht

RE: $$Excel-Macros$$ Name Manager

2012-05-12 Thread Rajan_Verma
Name manager is used to Assign a Name to a Range on worksheets After define a name you can refer that range by that Name you assigned 1) Press Ctrl+F3 2) Alt+N (New) 3) Fill the Name 4) Select the Scope 5) Select the Range If Your Define a name rngMyRange fo