Can you post your code?


On Fri, 24 Sep 2004 12:04:08 GMT, "Joseph Czapski" wrote:

"Dave Peterson" wrote:
I don't think so.

This worked for me:

Option Explicit
Sub testme()
ActiveSheet.Cells.Value = 1
End Sub


All 16,777,216 were changed to 1.

You may want to be a little more specific.

Dave,
Thank you very much for testing that! That's good info. Did that write all
the cells at once, though? This problem has to do with updating one cell at
a time, and Show-ing each cell after it's updated, as data comes into the
computer one cell-worth at a time. After the 2,560th cell is updated, Excel
pops up a window saying that I've exceeded "2,560 cells or rows".

Joe Czapski
Boston, Mass.