| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
putting values into cells is slow
In a program, I have
n=500 application.screenupdating=false For i=1 to n cells(i,6).value=cells(i,5).value*35 cells(i+n,6).value=cells(i,4).value*76 next i application.screenupdating=true This takes an age to run, especially if n is really large. There must be a faster (better) way of doing this - can anybody help please? Thanks Chris |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| taking numbers in vertical cells putting them in horizontal cells | Excel Worksheet Functions | |||
| Adding values from 1 workbook based on criteria & putting in anoth | Excel Discussion (Misc queries) | |||
| chart keeps putting the values together on same line | Excel Discussion (Misc queries) | |||
| Adding values in sheets and putting them on a summery | Excel Worksheet Functions | |||
| Putting correct values in cells | Excel Programming | |||
Threaded Mode
