Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
This simple routine has crept into my code and I use it thoughtlessly and
often: For i = 1 To 50000 ' some seriously large value here! Range("C" & i).Value = Range("A" & i).Value + Range("B" & i).Value Next i I discovered it is a time-consumer, searched for alternatives and found several, but am just not VBA fluent enough to judge their efficiency. Any more experienced programmers can help me find the truly fastest solution? Thanks! -Joni |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Large Time totals not summing. | Excel Worksheet Functions | |||
Large Time values not summing | Excel Worksheet Functions | |||
more efficient way to lookup a range? | Excel Discussion (Misc queries) | |||
Summing large numbers... | Excel Worksheet Functions | |||
Summing large columns | Excel Worksheet Functions |