+ Reply to Thread
Results 1 to 2 of 2

Reduction of code lines to speed up macro

  1. #1
    Forum Contributor
    Join Date
    04-12-2013
    Location
    Usually at work, in the UK
    MS-Off Ver
    Excel 2010
    Posts
    639

    Reduction of code lines to speed up macro

    How would I put the following onto a single line and have the code still work?

    Range("AH2").Formula = "=IF(ISERROR(INDEX('[Daily MI Master Template.xlsm]MI'!$X$86:$X$13952,MATCH(A2,'[Daily MI Master Template.xlsm]MI'!$T$86:$T$13952,0))),"""",INDEX('[Daily MI Master Template.xlsm]MI'!$X$86:$X$13952,MATCH(A2,'[Daily MI Master Template.xlsm]MI'!$T$86:$T$13952,0)))"
    Range("AF2:AF" & RowL).FillDown

  2. #2
    Forum Contributor
    Join Date
    04-12-2013
    Location
    Usually at work, in the UK
    MS-Off Ver
    Excel 2010
    Posts
    639

    Re: Reduction of code lines to speed up macro

    Still could do with some help on this though (other thread marked as solved as it was a duplicate)

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Macro on 2500 lines - looking to increase speed by defining variables?
    By Londonbound in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-06-2016, 09:59 AM
  2. [SOLVED] VBA code for data reduction of csv files
    By seawise in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-04-2016, 12:00 PM
  3. Speed up macro - shapes slows code
    By Lukael in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-17-2014, 01:29 PM
  4. How to improve the running speed of this VBA macro code?
    By sellim in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-24-2012, 01:45 PM
  5. speed up vba code within excel macro
    By MOSHEBS in forum Excel General
    Replies: 3
    Last Post: 09-25-2011, 08:23 AM
  6. code for reduction
    By raviexcel in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-24-2010, 04:59 AM
  7. how to speed up macro code execution?
    By sharmanjali87 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-03-2010, 06:45 AM

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