About a year ago I published an article in a Dutch magazine about using defined names in Excel.
I thought it was high time to translate that article into English and publish it on my site.
Here’s the introduction of the article:
Defined Names In Excel
In Excel you can give a range of cells a name. When you do that, you can use this name instead of the address to point to that range. In general it is easier to remember a name than a range address of the start and end of a range of cells.
Using names has a couple of advantages: ranges are easier to find, formulas are simpler to understand and maintenance of the spreadsheet model becomes more reliable.
Furthermore, some thingsin Excel can only be achieved bij using defined names. But much more is possible with defined names than just naming a range of cells. Because you can also put a formula into a name, a whole world of possibilities opens up!
Even more so, since you can also put the old Excel 4 macro functions to use in a defined name. This enables you to do things normally only possible using VBA.
And here’s the TOC:
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
Go and read it, then tell me what you think of it!
Jan Karel Pieterse