TableMath Macro: Purpose, Usage, and Issues

 Last reviewed: July 30, 1997
Article ID: Q110165
The information in this article applies to:
  • Microsoft Word for Windows, version 6.0

SUMMARY

This article discusses the purpose, usage, and known support issues for the TableMath macro, supplied with Word version 6.0 for Windows in the TABLES.DOT file.

MORE INFORMATION

PURPOSE OF THE MACRO

The TableMath macro makes it easier to develop formulas to use in tables.

HOW TO USE THE MACRO

For more information on how to use the macro, see the macro's online Help system or query on the following words in the Microsoft Knowledge Base: 

   tablemath and wordbasic and 6.0

KNOWN ISSUES

When you use the TableMath macro, you may receive the following errors:

  • Error #143 ("Command Failed") when double-clicking a Value item.
  • Error message when using Subtraction.
  • Target cell contents not appearing in the Show Value message box.
  • Status bar loses text.
  • Table Cells are selected but none appear in macro.

Error #143 ("Command Failed") when double-clicking a Value item

This error occurs when you double-click the last item in the Values list box.

To work around this problem:

  1. Select the final item in the Values list.
2. Click the Exclude button. (This will remove the item from the list 
   without the error message appearing.)

Error message when using Subtraction

When the Subtraction function is selected when a range is in the Values list box, the following message appears: 

   The SUBTRACTION (-) function cannot operate on more than one value.
To work around this problem:

  1. Remove the range from the Values list box.
2. Change to the Subtraction function. 3. Re-add the cells individually.

Target cell contents not appearing in the Show Value message box

This problem occurs if all of the following are true:

  • The Clipboard check box is not checked.
  • A cell is selected in the Target list box.
  • The Show Value button is clicked.

The result displayed in the message box will be the active cell in the List list box.

To work around this problem:

  1. Click in the List list box.
2. Select the target cell. 3. Click the Show Value button.

Status Bar Loses Text

When a message appears on the screen, the text in the status bar disappears and is not replaced. This happens because the message box places "For Help, press F1" in the status bar by default.

Currently there is no workaround.

Table Cells are selected but none appear in macro

This problem occurs if part or all of the table is selected along with something outside of the table. This is by design; if a table cell is part of the formula and it is pasted outside of the table, the resulting field will return an error.

Kbcategory: kbusage kbmacro KBSubcategory:

Additional query words: 6.0 TableMath macro hangs stops word6
winword WordBasic
Version : 6.0
Platform : WINDOWS

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: July 30, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.