Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Experts,
I am running my macro and its taking almost 5 minutes during execution on my computer (2GB RAM). Is there any way by which I can reduce this execution time? Here is the code... With wbSource.Worksheets("Flowdate") For j = 24 To 36 Step 4 row_price = 2315 For i = 0 To 364 peak_price = .Cells(row_price, j).Value If peak_price = "" Then Worksheets("Flowdate").Cells(row_price, j).Value = Worksheets("Flowdate").Cells(row_price, j).Offset(0, 2).Value End If offpeak_price = .Cells(row_price, j + 1).Value If offpeak_price = "" Then Worksheets("Flowdate").Cells(row_price, j + 1).Value = Worksheets("Flowdate").Cells(row_price, j + 1).Offset(0, 2).Value End If row_price = row_price + 1 Next MsgBox "Calculation done" Next End With |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How can I reduce repetative code | Excel Discussion (Misc queries) | |||
Any way to reduce/combine in this code? | Excel Programming | |||
Reduce code | Excel Discussion (Misc queries) | |||
VBA Code execution delay | Excel Programming | |||
Code execution has been interrupted | Excel Programming |