Named Ranges

Named Range Tutorial

These Excel ('97 and 2000) files and Word files were done for the UK MEI Mathematics conference, Summer 2000. As such they were done whilst my Excel and VBA knowledge was much more impoverished than it is at present - enough said!

However, the associated Word files are quite detailed and will hopefully give the interested user a useful start if they are unfamiliar with the work.

Notice that, in addition to the Word files, the associated, completed Excel files are also provided (Though I suggest if you are learning that you DON'T actually look at them but work through the Word file instructions first).

My advice is for you to download the files directly to your hard drive by right-clicking on the link and then selecting "Save Target As..." - otherwise the Excel files may not work fully in your browser window!

Word Files	Excel Files	Description
ReadMeFirst (40KB)		A quick read regarding Worksheet Calculation Modes will avoid confusion!!
Name1 (96KB)	Name1 (28KB)	Introduction to Named Ranges, pros and cons. Using Named Range references for Graph Series. (Automatic Calculation Mode needed)
Name2 (44KB)	Name2 (31KB)	Multiple and Interactive Graphs on the same axes using Named Ranges. (Automatic Calculation Mode needed)
Name3 (134KB)	Name3 (38KB)	Intentional circular references using Named Ranges are used to animate a tangent to a graph. The tangent being drawn using a simple User-Defined-Function (UDF) programmed into the Visual Basic Editor. This is an easy introduction to the VBA world! (Manual Calculation Mode needed)
Name4 (131KB)	Name4 (27KB)	Further, intentional circular references using Named Ranges are used but this time to animate a Cosine Graph. This shows how the unit circle is used to construct the familiar Cosine Curve. Of particular interest is a detailed analysis of how to customise the familiar pie chart so as to become an angle measure indicator. (Manual Calculation Mode needed)
Name5 (101KB)	Name5 (56KB)	A fairly technical file which uses techniques developed above to draw two graphs. The first of these has an animated tangent to a cubic curve the length of which is proportional to its magnitude - that is its length is zero at any turning points. The second graph plots the signed magnitude of the tangent from the first graph. Naturally, this produces a quadratic and is a demonstration of how a tangent graph is constructed from a given (cubic) function. (Manual Calculation Mode needed)
Bibliography (30KB)

VBA Programming Tutorial

An additional Dynamic Named Range Tutorial type Excel file.

Links