| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cumbersome Code
The following code takes a R E A L L Y long time (90 seconds), processing around 2000 records. Is there any way to speed it up?
.Columns("Y").NumberFormat = "0" For i = 3 To (numberofRows - 2) If .Range("CE5") = "DIST" Then If .Cells(5, 86).Value - .Cells(i, 25).Value 0 Then .Cells(i, 57).Value = .Cells(5, 86).Value - .Cells(i, 25).Value Else End If .Cells(i, 57).Value = 0 End If Next Thanks, Jim Berglund |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cumbersome IF Statement | Excel Discussion (Misc queries) | |||
| Iserror is too cumbersome as I use it - is there an alternative? | Excel Worksheet Functions | |||
| Non cumbersome way to hide and protect a column? | Excel Worksheet Functions | |||
| nested IF AND too cumbersome | Excel Worksheet Functions | |||
| cumbersome sheets on Word | Excel Worksheet Functions | |||
Linear Mode
