Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
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 |