NAMING RANGES AND WRITING MACROS

Abstract

I recently developed a spreadsheet template that would summarize the year‐to‐date expenditures and encumbrances of a library and calculate the balance left in the budget. One of the design objectives was to minimize the number of instructions for clerical workers who would be using the template. Macros, or programmed sequences of key‐strokes, had to be developed—and when using macros, it is best to do a lot of range naming in order to keep things understandable.

Citation

Clark, P. (1990), "NAMING RANGES AND WRITING MACROS", The Bottom Line, Vol. 3 No. 3, pp. 33-34. https://doi.org/10.1108/eb025243