Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Speed of array formula | Excel Worksheet Functions | |||
Speed of fixed array versus dynamic array | Excel Programming | |||
Using an Array instead of a Vlookup to improve speed | Excel Programming | |||
Speed up performance for very big array | Excel Programming | |||
VBA - speed up macro, working with array? | Excel Programming |