+ Reply to Thread
Results 1 to 4 of 4

Speed of macro changes if split and saved

  1. #1
    Registered User
    Join Date
    10-20-2011
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    2

    Speed of macro changes if split and saved

    I have an issue which I'm getting around by running two macros at the moment but I'm sure it's a fairly simple fix and would like to combine the macros.

    I have a very large spreadsheet with 147k rows and 54 columns. A lot of the data is unnecessary and so the first step of my macro is to delete all but four relevant columns.
    It then does some sorting and text to numerical conversion before completing.

    What I noticed was that if I saved after this step - my next macro ran a LOT faster.
    (This one just deletes specific lines).

    I'm guessing this is related to the initial filesize being changed by my save and without it - excel still see's it as large despite my deletion of the majority of columns.

    Anyone any idea as to how I could introduce code to combine the macros but keep the speed?

  2. #2
    Registered User
    Join Date
    10-20-2011
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Speed of macro changes if split and saved

    Please let me know if this question is unclear!

  3. #3
    Forum Expert Whizbang's Avatar
    Join Date
    08-05-2009
    Location
    Greenville, NH
    MS-Off Ver
    2010
    Posts
    1,395

    Re: Speed of macro changes if split and saved

    Please post your code for both macros.

  4. #4
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,974

    Re: Speed of macro changes if split and saved

    Did you try having the macro save the file in the middle?
    Everyone who confuses correlation and causation ends up dead.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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