PRB: Mouse Cursor Flickers Between Pointer and Hourglass When Writing to Excel Through Automation (281851)
The information in this article applies to:
This article was previously published under Q281851 SYMPTOMS
When you write to 64 or more cells in a worksheet with the object model of Excel (that is, through Visual Basic for Applications (VBA) or by Automation), the mouse cursor flickers between a pointer and hourglass icon.
CAUSE
Excel is keeping the user informed about operations that may require a wait. However, if the operation is relatively quick, the user may experience a flicker when the mouse cursor is changed to an hourglass and back again.
RESOLUTION
If the flicker is unacceptable in your implementation, you can work around the problem by splitting up the arrays you write into 63 cell blocks, which avoids the code in Excel that changes the mouse cursor to an hourglass.
| Modification Type: | Major | Last Reviewed: | 10/2/2003 |
|---|
| Keywords: | kbAutomation kbnofix kbprb KB281851 |
|---|
|