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.
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
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