Chapter 3. Naming Hacks

     

Hacks #39-44

Section 39.   Address Data by Name

Section 40.   Use the Same Name for Ranges on Different Worksheets

Section 41.   Create Custom Functions Using Names

Section 42.   Create Ranges That Expand and Contract

Section 43.   Nest Dynamic Ranges for Maximum Flexibility

Section 44.   Identify Named Ranges on a Worksheet



Excel Hacks
Excel Hacks: Tips & Tools for Streamlining Your Spreadsheets
ISBN: 0596528345
EAN: 2147483647
Year: 2003
Pages: 136

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net