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
• Introduction • Define • Use • Absolute/Relative • Context • Special Names • Formula In Name • Dynamic Names • XLM In Names • Arguments • Bugs Name Obj. • Conclusion •

Search Zoeken

WWW
This site

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

Introduction

How To Define Range Names

How To Use Range Names

Absolute And Relative Addressing

The Context Of Names

Special Names

A Step Further: A Formula In A Defined Name

Dynamic Names

Another Step Further: XL4 Macro Functions In Names

Passing Arguments To A Defined Name Formula

Bugs in Excel's Name Object

Conclusion

 

Next>>

    Subscribe in a reader

powered by longhead.com

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