XL97: "Unable to Record" Message When Recording a MacroLast reviewed: February 12, 1998Article ID: Q166492 |
The information in this article applies to:
SYMPTOMSWhen you attempt to enter information into a cell, you may receive the following error message:
Unable to Record CAUSEThis problem may occur when the following conditions are true:
WORKAROUNDTo work around this problem, do not enter more than 255 characters per cell while recording a macro.
MORE INFORMATIONIn Microsoft Excel 97, you can use more than 255 characters in a cell; however, when you pass strings that are greater than 255 characters in length from a Visual Basic for Applications procedure, Microsoft Excel 97 retains the same design features that earlier versions of Microsoft Excel use. This limit applies to all strings that you pass from a Visual Basic procedure to a Microsoft Excel sheet; the limit does not apply exclusively to information that you pass to cells. For example, if you pass a text string that is longer than 255 characters to a text box on a worksheet or a dialog sheet, Microsoft Excel truncates the text even though a text box can hold up to 10,240 characters. For more information about string limits in Visual Basic for Applications, see the following article in the Microsoft Knowledge Base:
ARTICLE-ID: Q105416 TITLE : XL: Passed Strings Greater Than 255 Characters Are Truncated |
Additional query words: XL97
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |