Microsoft KB Archive/64159

Recalculating Specific Areas Within a Worksheet PSS ID Number: Q64159 Article last modified on 08-16-1990 PSS database name: D_MPlan

3.00 3.01 3.02 3.04 4.00 4.01 4.20

MS-DOS

Summary:

A simple macro can be created to recalculate one or more areas within a worksheet under Multiplan versions 3.00, 3.01, 3.02, 3.04, 4.00, 4.01, and 4.20. The macro command is “RR” and it is described in the Help menu. To access the Help menu, choose Help Macro and press the letter “N” (for Next) until the “RR” command is listed.

To create a macro, choose Alpha and enter “’RR” followed by the cell reference and a terminating “’” (without the quotation marks). Make sure that the “recalc:” field is set to No within the Options menu. The section below provides an example of how a simple macro can be created to recalculate two ranges within a worksheet.

More Information:

This section provides step-by-step instructions to create a macro that will recalculate the current cell, two cells to the immediate right, and the cell located in row 4 column 4. This macro can easily be adapted for other ranges and for use within other macros.

  Choose a cell outside the worksheet area to contain the macro that will be created. Move the cell pointer to this cell location. Choose the Name command and in the name field enter “test”. Set the “macro:” field to Yes. In the “command key(s):” field, enter one or two letters. For the purpose of this example, we will use the letter “z”. Press the ENTER key to return to the main menu.   Choose Goto Name and enter the word “test” to make sure that the cell pointer is within the test macro cell.   Choose Alpha. Make sure to include the apostrophes when entering the following text within the cell: ‘rrrc:rc[+2],r4c4’ Press the ENTER key. Note that this entry specifies the relative range of RC:RC[+2] and the absolute range of R4C4. Any number of ranges may be specified here separated by commas.   Choose Options and set the “recalc:” field to No.   Enter formulas in R4C4 and other areas of the worksheet. A simple formula could be “RC+1” (Add one to the current cell).   Move the cell pointer to any area within the worksheet containing formulas and execute the macro by holding down the ALT key while pressing the letter “z”. Note that the ranges specified in Step 3 are recalculated, but no other cells are recalculated. 

Copyright Microsoft Corporation 1990.