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

Article translations Article translations
Article ID: 281851 - View products that this article applies to.
This article was previously published under Q281851
This article has been archived. It is offered "as is" and will no longer be updated.
Expand all | Collapse all

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: October 26, 2013 - Revision: 4.0
Applies to
  • Microsoft Excel 2000 Standard Edition
Keywords: 
kbnosurvey kbarchive kbautomation kbnofix kbprb KB281851

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com