Thread: Array speed
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
leungkong leungkong is offline
external usenet poster
 
Posts: 32
Default Array speed

I use the following code to write the data from a (8615 * 24) array to
worksheet
It is very fast before.
But I don't know why it is slow now.
Today, I spend 2.5 hours for this.
I want to know why and how to speed up. Many thanks.

Dim i As Long, j As Byte
For i = LBound(RMaster) To UBound(RMaster)
For j = 0 To 23
Cells(i + 2, j + 1 = RMaster(i, j)
Next
Next