Microsoft KB Archive/68011

UAE Copy and Paste Recorded Macro with Custom Number Format PSS ID Number: Q68011 Article last modified on 02-26-1993 PSS database name: W_eXceL

2.10c 2.10d 3.00

WINDOWS

Summary:

An Unrecoverable Application Error (UAE) will be generated when a RECORDED macro with a custom number format is pasted into another macro sheet.

More Information:

The following is an example of a RECORDED macro that will generate a UAE when pasted into another macro sheet. If you enter the same macro manually and copy and paste the macro, the UAE is not produced.

Record1 =FORMAT.NUMBER(“0.000”) =RETURN

Steps to Reproduce Problem

 * 1) Activate sheet1.
 * 2) From the Macro menu, choose Record.
 * 3) From the Format menu, choose Number.
 * 4) Enter a custom format.
 * 5) From the Macro menu, choose Stop Recorder.
 * 6) Activate the macro sheet.
 * 7) Select the cells containing the macro.
 * 8) From the Edit menu, choose Copy.
 * 9) Open the new macro sheet.
 * 10) From the Edit menu, choose Paste.

A UAE will be generated when you complete step 10. This problem has been reproduced in Excel 2.10c and 2.10d.

This behavior hasn’t been reproduced in Microsoft Excel version 3.00.

Copyright Microsoft Corporation 1993.