Run the code faster.

[countryfan_nt]

Hello friends, hope all is well!
can you please help me make the below code run faster?

Thank you very much in advance!

Please Login or Register  to view this content.

[kev_]

Hi countryfan_nt

What are you trying to achieve here?

When do you expect this loop to terminate?:

Please Login or Register  to view this content.

[countryfan_nt]

B34 = the code above runs in cell B34, hence, values start from 0 and stops when C34 becomes TRUE.
C34 formula: =IF(E34<=B34,TRUE,B34).
E34 has the target value, to finally show the desired result.

[kev_]

Remove this line:

Please Login or Register  to view this content.

and move this line:

Please Login or Register  to view this content.

above this line:

Please Login or Register  to view this content.

[countryfan_nt]

done, but still not fast enough. you see this is feeds a chart, and I wish to see the chart results run faster.

[kev_]

To speed up processing
- use a variable to calculate
- write the result to the cell when condition satisfied

Try this:

Please Login or Register  to view this content.

EDIT - please note that I amended the code in a couple of places after posting

[countryfan_nt]

Thank you very much!

[kev_]

You are welcome. Thanks for reps and marking thread SOLVED