XL98: Insert and Delete Methods of Characters Class May Fail

ID: Q190189

The information in this article applies to:

Microsoft Excel 98 Macintosh Edition

SYMPTOMS

When you use the Insert method of the Characters class to insert more than 255 characters, the following symptoms may occur:

You receive the following error message:

      Run-time error '1004':
      Insert method of Characters class failed

    -or-

The Insert method fails to insert more than 255 characters.

NOTE: When you use the Delete method to delete more than 255 characters, similar symptoms occur.

CAUSE

The number of characters that you can insert or delete using the Insert or Delete methods of the Character class is limited to 255.

STATUS

Microsoft has confirmed this to be a problem in Microsoft Excel 98 Macintosh Edition.

REFERENCES

For more information about using the Insert method, start the Visual Basic Editor, click Office Assistant, type "Insert", click Search, and then click "Insert Method."

Additional query words: XL98

Keywords          : kbprg kbdta xlvbainfo 
Version           : MACINTOSH:98
Platform          : MACINTOSH
Issue type        : kbprb

Last Reviewed: February 23, 1999