Microsoft KB Archive/211885

= XL2000: Error Message Appears When You Run a Macro to Modify Cell Comments =

Article ID: 211885

Article Last Modified on 9/27/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q211885





SYMPTOMS
When you run a Visual Basic for Applications macro that modifies cell comments on a worksheet, the following error message may appear:

Run-time error '438':

Object doesn't support this property or method



CAUSE
You may see this behavior if you record a macro that moves or resizes the cell comment. The Macro Recorder does not properly record the selection of the comment, so the macro cannot modify the size or position of the comment on the worksheet.



WORKAROUND
To avoid this problem, add the following two lines of macro code before the line that reads "Selection.RangeShape..." (without quotation marks) in the recorded macro: Range.Comment.Visible = True Range.Comment.Shape.Select True



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

Additional query words: XL2000 Run time error 438 Object doesn t support this property or method

Keywords: kberrmsg kbbug kbprogramming kbpending kbcode KB211885

-

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

© Microsoft Corporation. All rights reserved.