Named Ranges

:: Named ranges can enhance worksheets, making formulas easier to interpret and making macros more flexible.
:: What is a named range in Excel? - Select a cell or group of cells. Then press Ctrl+F3 or go to Insert > Name > Define .... You can then use the name in place of the cell reference in your formulas and macros.

Links in This Category: 3

Performance Analysis using Named Ranges www.grbps.com
	Analysing performance data in Excel using array formula and dynamic range name methods. This is an interesting article on how to use named ranges effectively.
Rating: (0 votes) - Details - Added: 06-02-2004 - Hits: 2442 - Error?

Dynamic Named Ranges
	Possibly one of Excels most underutilized aspects is its ability to create dynamic named ranges that will expand and contract according to the data in them. Here are 7 different types of these ranges.
Rating: (1 votes) - Details - Added: 05-12-2006 - Hits: 1953 - Error?

Excel Named Ranges OzGrid.com
	Named Ranges in Excel have been around a long time. Using them frequently is a very good habit to form. Find out more at OzGrid.com.
Rating: (1 votes) - Details - Added: 05-12-2006 - Hits: 1549 - Error?

Microsoft® and Microsoft Excel® are registered trademarks of Microsoft Corporation. This site is in no way associated with Microsoft.