LEFT(A1,3) or LEFT(RC[-1],3) which one is more speedy ?

[nur2544]

I know below both formula are same, but which one is more speedy as it will fill down till A65536

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[scott.s.fower]

they are exactly the same in terms of speed. to speed things up you can turn off screen updating and switch automatic calculation off until the end of the macro.

[mc84excel]

I know below both formula are same, but which one is more speedy as it will fill down till A65536

Hello nur2544

I tested both down to row 65536 and they ran at 1.15 seconds each. (I did use screen updating off/on however). So my conclusion is that there is no noticeable difference between either method.

Should you want to test this for yourself, please find code below:

Please Login or Register  to view this content.

[nur2544]

Hi, mc84excel
You did excellent job for me , & Very well explanation , now I am very happy to get the answer practically,
so From now onward I will use direct formula inside the macro module except RC style as the speed Of running macro is same. Before that I thought there might be speed issue , I thought like this First formula is converted into RC style then run the macro module & for this there might be some delay
However I got your point & thanks again for remembering my issue as well as me, I am glade for this Take care…