PRB: Mouse Cursor Flickers Between Pointer and Hourglass When Writing to Excel Through Automation

This article was previously published under Q281851
This article has been archived. It is offered "as is" and will no longer be updated.
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.
Properties

Article ID: 281851 - Last Review: 10/26/2013 16:43:00 - Revision: 4.0

  • Microsoft Excel 2000 Standard Edition
  • kbnosurvey kbarchive kbautomation kbnofix kbprb KB281851
Feedback