+ Reply to Thread
Results 1 to 6 of 6

Out of memory error

  1. #1
    Registered User
    Join Date
    04-20-2015
    Location
    Norway
    MS-Off Ver
    360
    Posts
    24

    Out of memory error

    Hi, I got help with this code a while ago – And it works great!
    However, now my data set is bigger and I’m getting an “out of memory” error.

    This is what I’m doing:

    - Sheet 1 and 2 have data in 20-80 columns with 100k-600k rows.
    - Both sheets have an “Unique-ID” in column A – of which about 80% match.
    - Purpose: New sheet 3 with the matches from sheet 1 and 2 in the same row.

    Is there a way to make the code more efficient?

    I'm having trouble with attaching files, does linking work?
    http://www.excelforum.com/attachment...9&d=1456057518

    Please Login or Register  to view this content.

  2. #2
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,379

    Re: Out of memory error

    Maybe an:

    Please Login or Register  to view this content.
    here and there could fix it
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  3. #3
    Registered User
    Join Date
    04-20-2015
    Location
    Norway
    MS-Off Ver
    360
    Posts
    24

    Re: Out of memory error

    Hi! Thanks for taking the time to reply.

    I'm not very happy with how I asked the question, so I've made a new thread and tried to clean it up.
    http://www.excelforum.com/excel-prog...ss-memory.html
    Last edited by Karl Gustaf Karsten; 02-23-2016 at 02:03 PM.

  4. #4
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,379

    Re: Out of memory error

    Hi Karl,

    The new thread is inaccessible!

  5. #5
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,379

    Re: Out of memory error

    Hi Karl,

    The new thread is inaccessible!

  6. #6
    Registered User
    Join Date
    04-20-2015
    Location
    Norway
    MS-Off Ver
    360
    Posts
    24

    Re: Out of memory error

    Sorry about that!

    http://www.excelforum.com/excel-prog...ss-memory.html

    Hope that one works?

+ 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] Out of Memory Error
    By chaddug in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-09-2015, 03:47 PM
  2. Replies: 1
    Last Post: 12-08-2011, 08:52 AM
  3. Out of Memory Error
    By Gregory Kip in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-02-2006, 06:35 PM
  4. getting error out of memory
    By Hilda in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-12-2006, 02:40 PM
  5. Out of memory error
    By funkymonkUK in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-14-2005, 07:33 AM
  6. [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
  7. [SOLVED] Out of Memory Error 7
    By Paul Black in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 06-24-2005, 09:05 AM

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