Knowledge Base

XL97: Error Running Macro To Modify Cell Comments

Article ID: 166141

Article Last Modified on 11/4/2000

Microsoft Excel 97 Standard Edition

This article was previously published under Q166141

SYMPTOMS

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

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 record the selection of the Comment properly, which is necessary for modifying 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... in the recorded macro:

   Range(<cell reference>).Comment.Visible = True
   Range(<cell reference>).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: Run-time error 438 Object doesn t support this property or method

Keywords: kberrmsg kbbug kbprogramming kbpending kbcode KB166141