XL97: Error Running Macro To Modify Cell Comments (166141)
The information in this article applies to:
- Microsoft Excel 97 for Windows
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
STATUSMicrosoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
| Modification Type: | Major | Last Reviewed: | 11/4/2000 |
|---|
| Keywords: | kbbug kbcode kberrmsg kbProgramming KB166141 |
|---|
|