Microsoft KB Archive/929999

= Error message when you try to run a procedure in Excel 2007: &quot;Run-time error&quot; =

Article ID: 929999

Article Last Modified on 10/15/2007

-

APPLIES TO


 * Microsoft Office Excel 2007

-



SYMPTOMS
When you try to run a procedure in Microsoft Office Excel 2007, you receive an error message that resembles the following error message:

Run-time error '-2147024809 (80070057)':

The item with the specified name wasn't found.



CAUSE
This issue occurs because there are more spaces in the item's name as it is used in the procedure than there are in the item's actual name. For example, the following code will not reference an item whose actual name is &quot;chart 1.&quot; ActiveSheet.Shapes(&quot;chart  1&quot;).Height = 9 This issue may occur when you try to run a procedure that was created in Microsoft Office Excel 2003. There was a problem in Excel 2003 in which multiple spaces were treated exactly like one space. This problem was corrected in Excel 2007.

Additional query words: xl2007

Keywords: kberrmsg kbtshoot kbprb kbexpertisebeginner KB929999

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.