Defined Names

JKP Application Development Services.

Microsoft Office Application Development

Defined Names

Up • Defined Names • Corrupt Files • Create Addins • Startup Problems • Chart an Equation • Show Picture • Round2Digits • Control Events • Custom Find • FormulaWrapper • Disable Events • Workbook Open Bug • WebQuery • Register UDFs • Undo With Excel VBA • Select a range (VBA) • Transpose Table • Docking VBE Windows • Excel 2007 Tables • Excel 2007 Tables (VBA) • Update An Addin • Addin Installation • Object Lister • Excel 2007 FileFormat • Catch Paste • Listbox AutoSize • Fix Links to UDFs

• Introduction • Define • Use • Absolute/Relative • Context • Special Names • Formula In Name • Dynamic Names • XLM In Names • Arguments • Bugs Name Obj. • Conclusion •

Search

Zoeken

Go to	Ga Naar
Home Up Introduction Define Use Absolute/Relative Context Special Names Formula In Name Dynamic Names XLM In Names Arguments Bugs Name Obj. Conclusion

Donate	Donaties
Did you find something helpful on my site? Consider a donation! Heeft u iets gevonden waar u wat aan had? Overweeg dan een donatie!

Introduction 1 2 3 4 5 6 7 8 9 10 Conclusion

Range Names in Excel

This article has been published (in Dutch) in the Office magazine (Number 21, April 2004).

Contents

How To Define Range Names

How To Use Range Names

Absolute And Relative Addressing

The Context Of Names

A Step Further: A Formula In A Defined Name

Another Step Further: XL4 Macro Functions In Names

Passing Arguments To A Defined Name Formula

Bugs in Excel's Name Object

statistics

Subscribe in a reader

Use the contact page to issue questions or comments about this website.
Copyright © 2003-2008 JKP Application Development Services