» Range Name Syntax
CATEGORY - Excel Range Name
VERSION - All Microsoft Excel Versions
Name syntax rules:The Name string must begin with a text character, not a number, and consists of adjacent characters.
Two words can be joined with an underscore (_), for example, to enter the Name "Excel Book", you should type Excel_Book.
You cannot use a Name that could otherwise be confused as a cell reference, for example, A1 or IS2002, as these are already cell references.
Notes:
There is no limit on the number of Names you can define.
Be sure to define unique Names for a specific workbook. Defining Names that resemble Names in other sheets will only complicate your work.
Book Store:
Recommended Books:
- Business Analysis and Valuation: Using Financial Statements, Text and Cases
- Lower Your Taxes - Big Time! : Wealth-Building, Tax Reduction Secrets from an IRS Insider
- The Essential 55: An Award-Winning Educator's Rules for Discovering the Successful Student in Every Child
- Microsoft Word Version 2002 Inside Out
- The Analysis and Use of Financial Statements
- Writing Excel Macros with VBA, 2nd Edition
No comments have been submitted.
