Most people who use computer software will find themselves having to repeat a process of steps to perform some task. For example, an Excel user might have to update a worksheet every week with the weekly expenses. The task might involve a series of operations which are repeated every time the task becomes necessary, such as copying a cell range of data, pasting, clearing, saving, and many other possibilities. A macro provides a way of recording these operations so that the user does not have to retype all the same sequence of tasks each time. A macro is a sequence of commands that can run automatically within an application such as Excel or Word. A macro is often referred to as a procedure. The commands that can be performed with a macro include any operation that can be performed within that application.

You can use the Name command in the Insert menu to create a mnemonic name for a cell range, such as D1:E15. These named ranges can be referred to by the chosen name. Using named ranges is strongly recommended because it is much easier to understand the meaning of a named range than the standard cell range reference. Once you have created a named range, it will then be visible in the Name box which appears to the left of the Formula bar. You can see from Figure 2.1, that the range of cells called month_no has been currently selected. This range consists only of

0 0

Post a comment