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.
↑ Back to the top
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.
↑ Back to the top
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.
↑ Back to the top