+ Reply to Thread
Results 1 to 4 of 4

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

  1. #1
    Forum Contributor
    Join Date
    06-08-2012
    Location
    BD
    MS-Off Ver
    Excel 2007
    Posts
    601

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

    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.

  2. #2
    Valued Forum Contributor
    Join Date
    11-20-2012
    Location
    Seattle, WA USA
    MS-Off Ver
    Excel 2010
    Posts
    597

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

    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.

  3. #3
    Valued Forum Contributor
    Join Date
    08-29-2012
    Location
    In lockdown
    MS-Off Ver
    Excel 2010 (2003 to 2016 but 2010 for choice)
    Posts
    1,766

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

    Quote Originally Posted by nur2544 View Post
    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.
    Last edited by mc84excel; 02-26-2013 at 07:32 PM. Reason: typo
    *******************************************************

    HELP WANTED! (Links to Forum threads)
    Trying to create reusable code for Custom Events at Workbook (not Application) level

    *******************************************************

  4. #4
    Forum Contributor
    Join Date
    06-08-2012
    Location
    BD
    MS-Off Ver
    Excel 2007
    Posts
    601

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

    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…

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1