+ Reply to Thread
Results 1 to 2 of 2

Out of Memory Error during editing

  1. #1
    Registered User
    Join Date
    06-28-2016
    Location
    Atlanta, GA
    MS-Off Ver
    Office 2016
    Posts
    7

    Out of Memory Error during editing

    I am using a combination of an RPA Client another with a third party database and VBA to create a full program to free up time for other tasks

    I use the RPA client to call on the Macros at different times during the process. That is why there are four different macros stored in this workbook.

    The current issue I have is i keep getting an "Out of Memory Error" as I try to edit and add portions to this process.

    IE ) I tried to add CutCopy = False to the program just to clear the clipboard and I am getting the error and i cannot add the code line.

    I am not the most efficient at VBA, so does anyone see why i would be getting this issue?

    Quick rundown of the full process

    Use RPA to open the Excel File
    1 - use ClearContents Macro to delete all Data on Data Input page
    2 - use RPA client and third party database to copy 150K records to excel file
    3 - Use RPA to call on Macros



    This macro clears contents and deletes all rows from the main Import sheet so new data can be pasted
    Please Login or Register  to view this content.
    This macro formats all rows and columns to autofit. The data from the third party database will paste awkwardly.
    This macro also deletes any duplicate header rows copied over.
    Ths macro also copies which database the data came from if a given value is null
    Please Login or Register  to view this content.
    This macro does the following
    Copies blank IDs to a new sheet
    Copies Blank Secondary Ids to a different new sheet
    Copies two columns of Ids and paste unique values to a new sheet.
    Writes formula to Count the number of times those values appear.
    paste formula as values.

    Please Login or Register  to view this content.

    Hopefully this all makes sense and if any more information is needed I can try to provide.

  2. #2
    Valued Forum Contributor
    Join Date
    11-26-2012
    Location
    Sydney
    MS-Off Ver
    2010
    Posts
    393

    Re: Out of Memory Error during editing

    Here are some ideas that might help:

    Do you need to copy and paste, or can you set the cell values directly, e.g.
    Please Login or Register  to view this content.
    Deleting Rows individually is probably taking a lot of time - it would likely be much quicker to sort the data first, then delete everything in one go (and then resort if needed).

    Also, you declare lastRow as Double - Long is more appropriate.

+ 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. [SOLVED] Thrashing VBA Memory Leaks. Memory Loop Problems. Uncleared Memory in .Match Range Object
    By Doc.AElstein in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-10-2017, 05:17 PM
  2. Out of memory error
    By ImranBhatti in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-09-2017, 03:29 AM
  3. Out of Memory Error
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-29-2016, 08:30 AM
  4. Out of memory error
    By Karl Gustaf Karsten in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-23-2016, 02:00 PM
  5. Replies: 1
    Last Post: 12-08-2011, 08:52 AM
  6. [SOLVED] getting error out of memory
    By Hilda in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-12-2006, 02:40 PM
  7. [SOLVED] How to handle error 8007000e Memory Error
    By L. A. M. in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-27-2005, 11:05 PM

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