» Range Name Syntax
CATEGORY - Excel Range Name
VERSION - All Microsoft Excel Versions
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:
- Lower Your Taxes - Big Time! : Wealth-Building, Tax Reduction Secrets from an IRS Insider
- Advanced modelling in finance using Excel and VBA
- Learn MS Excel 2002 VBA/XML Programming
- Managing by the Numbers: A Commonsense Guide to Understanding and Using Your Company's Financials: An Essential Resource for Growing Businesses
- Accounting and Financial Fundamentals for Nonfinancial Executives
- Absolute Beginner's Guide to Microsoft Office Excel 2003
No comments have been submitted.
