Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Slow VBA code....Hide/Unhide Loop | Excel Worksheet Functions | |||
VBA loop slow if another workbook open | Excel Discussion (Misc queries) | |||
Exceptionally large files | New Users to Excel | |||
Loop too slow deleteing xltoleft | Excel Programming | |||
slow program in a loop | Excel Programming |