Excel: Using COMPARE.XLA Generates Macro Error

• 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 

REFERENCES

"User's Guide 1," version 4.0, page 301
"User's Guide" for Windows, version 3.0, pages 695-696
"User's Guide" for the Macintosh, version 3.0, pages 691-692

Additional query words: 3.0 add in

Keywords :
Version :
Platform :
Issue type :