EXCEPTIONALLY SLOW LOOP ....help!!!
Have you turned screen updating off when populating the sheet? i.e.:
Application.ScreenUpdating = False
For...
Application.ScreenUpdating = True
And your row placement for placing the values is very sparse. I.e.
Rows 2, 23, 44, 65. Is that what you really want?
SteveM
WhytheQ wrote:
I can't see any reason why the following loop should take so long to
execute.....
For i = 1 To 35
For j = 1 To 20
Worksheets("Income").Cells(20* (i - 1) + j + 1, 200) =
income(i, j)
Next j
Next i
....the 2 dimensional array 'income' has been filled, before the above
executes, with the correct numner of elements i.e income(1 to 35,1 to
20).
It's like watching paint dry when the above executes!
Any help greatly appreciated.
Jason
|