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.
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.
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.
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.
Contact us for more help
Connect with Answer Desk for expert help.