Microsoft KB Archive/86685

{|
 * width="100%"|

Excel: Using COMPARE.XLA Generates Macro Error

 * }

-

The information in this article applies to:


 * Microsoft Excel for Windows, versions 3.0, 4.0
 * Microsoft Excel for the Macintosh, versions 3.0, 4.0
 * Microsoft Excel for OS/2, version 3.0

-

SUMMARY
The COMPARE.XLA (Windows and OS/2) and WORKSHEET COMPARISON (Macintosh) add- in macros included in the Microsoft Excel versions mentioned at the beginning of this article may generate a macro error when you compare two files that contain long formulas or other data.

MORE INFORMATION
COMPARE.XLA (Windows and OS/2) and WORKSHEET COMPARISON (Macintosh) are add-in macros that compare two worksheets on a cell-by-cell basis and then create a new worksheet that displays the differences between the worksheets being compared.

Listed below are the limits of cell comparison for Microsoft Excel 3.0 and 4.0.

If you exceed these limits, you will receive the macro error messages.

Version of      Combined length of    Error message if limit is exceeded Microsoft Excel cells being compared cannot exceed

3.0 for the     466 characters        Macro error at cell: Worksheet Macintosh                             Comparison!B55

3.0 for Windows  212 characters       Macro error at cell: COMPARE.XLA!B53

4.0 for the     466 characters        Macro error at cell: Worksheet Macintosh                             Comparison!B63

4.0 for Windows 476                   Macro error at cell: COMPARE.XLA!B63 characters