Lotus 1-2-3 Macros
FILES IN THE _123 DIRECTORY:
Load POINT.WK1 into Lotus 1-2-3 and position the cursor on a blank
cell somewhere below the macro text. Type a few numbers like 1234
and 7896. Then, press
Now, type a few more values. Notice that the decimal point is
now automatically inserted.
command /XMmessage~location~ is handy for more than just making
menus. For the purposes of this demo, cell A6 holds the macro's
range name as the label \P. The macro itself begins in the cell to
the right, B6, with a /XM command that specifies the cell containing
the message to be highlighted, in this case, cell B8. The cell below
the /XM command is blank to let you press
When you press
under the message is displayed on the control panel beneath the
message. After 1-2-3 displays the message, the macro pauses.
falls to the cell below the /XM command, which, because it is empty,
halts the macro. Pressing
below the second message line, cell B10, which contains the commands
to print a previously defined range named REPORT.
DEMO.WK1 illustrates how to simplify writing Lotus 1-2-3 formulas to
sum columns with subtotals, usually a time-consuming and error-prone
task. To use the macro, assign a range name SUM to the column's
range and a second range name TARGET where the total should appear.
When you then press
with an @SUM() function for the SUM range. An EDIT function changes
this temporary string into a formula by deleting the label prefix.
The macro assumes that subtotals are preceded by a line drawn with
the \- command, as is usually the case. The @CELLPOINTER("CONTENTS")
function searches for rows with dashes, locating subtotals, which are
then subtracted from the sum.
"Making a Point With 1-2-3" by L. D. Mashburn, June 1988
"Prompting With 1-2-3 Menus" by Don Nummi, Jr., March 1988
"1-2-3 Totem Pole Totals" by Brian T. Copeland, December 1988