+ Reply to Thread
Results 1 to 5 of 5

MACRO runs very slowly, getting Run out of Memory error

  1. #1
    Forum Contributor
    Join Date
    07-29-2013
    Location
    Oshawa
    MS-Off Ver
    Excel 2010
    Posts
    660

    MACRO runs very slowly, getting Run out of Memory error

    Hi everyone,

    I have the following code:

    Please Login or Register  to view this content.
    The CORE_DD code is a slightly modified version of an old code i have that works perfectly. When I run the code on my new template, it first runs extremely slowly and then I get a Run out of Memory error. When I look at the new workbook that's been opened, it appears the summary page has been copied but the formulas were copied as well where as it should only be the values.

    Any ideas how I can speed this up and actually have the values copied to the new workbook?

    thanks everyone!!

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,512

    Re: MACRO runs very slowly, getting Run out of Memory error

    Does this work any better?
    Please Login or Register  to view this content.
    If posting code please use code tags, see here.

  3. #3
    Forum Contributor
    Join Date
    07-29-2013
    Location
    Oshawa
    MS-Off Ver
    Excel 2010
    Posts
    660

    Re: MACRO runs very slowly, getting Run out of Memory error

    Hi Norie,

    Thanks very much. I've tried your adjustment and it seemed to start working faster but I got the Run out of Memory error again and it appears the formulas have been copied into the new workbook instead of just the values from the original. Any ideas?

    Thanks!

  4. #4
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,512

    Re: MACRO runs very slowly, getting Run out of Memory error

    The formulas will be copied to the new workbook but then they should be replaced with values here.
    Please Login or Register  to view this content.
    If that's not happening how about this?

    Copy the template worksheet to the end of the main workbook, replace formulas with value in the copied sheet and then move that sheet to a new workbook.
    Please Login or Register  to view this content.

  5. #5
    Forum Contributor
    Join Date
    07-29-2013
    Location
    Oshawa
    MS-Off Ver
    Excel 2010
    Posts
    660

    Re: MACRO runs very slowly, getting Run out of Memory error

    hi Norie,

    That worked perfectly! Thanks very much!

+ 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. 2010 macro runs slowly in 2013
    By PaulieNZ in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-24-2013, 09:00 PM
  2. Macro runs Slowly
    By Mysore in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 02-08-2012, 08:55 AM
  3. Imported UserForm runs slowly
    By pnmng49 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-03-2011, 10:39 AM
  4. Excel file runs slowly
    By john_london in forum Excel General
    Replies: 4
    Last Post: 09-27-2010, 10:51 AM
  5. [SOLVED] Out of Memory:Macro runs.
    By Richard in forum Excel General
    Replies: 1
    Last Post: 01-27-2005, 11:06 PM

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