+ Reply to Thread
Results 1 to 3 of 3

VBA code error: "out of memory"

  1. #1
    Registered User
    Join Date
    06-12-2018
    Location
    Rotterdam
    MS-Off Ver
    365
    Posts
    2

    VBA code error: "out of memory"

    Hi, i'm currently working on a project where Excel automatically fetches financial data of publicly traded companies.
    Sometimes I get the error:"out of memory". Is there a way to fix this?
    I'm using 64-bit Excel.

    Code:

    Please Login or Register  to view this content.
    Last edited by ToniSkulj; 07-10-2018 at 05:53 PM.

  2. #2
    Forum Expert
    Join Date
    10-10-2008
    Location
    Northeast Pennsylvania, USA
    MS-Off Ver
    Excel 2007
    Posts
    2,387

    Re: VBA code error: "out of memory"

    ToniSkulj,

    Welcome to the Excel Forum.

    Please see the forum rules, at the next link, on how to display macro code, and, also how to post your workbook:

    https://www.excelforum.com/forum-rul...rum-rules.html
    Last edited by stanleydgromjr; 07-10-2018 at 05:22 PM. Reason: additional instructions
    Have a great day,
    Stan

    Windows 10, Excel 2007, on a PC.

    If you are satisfied with the solution(s) provided, please mark your thread as Solved by clicking EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.

  3. #3
    Forum Expert
    Join Date
    10-10-2008
    Location
    Northeast Pennsylvania, USA
    MS-Off Ver
    Excel 2007
    Posts
    2,387

    Re: VBA code error: "out of memory"

    ToniSkulj,

    Welcome to the Excel Forum.

    Please see the forum rules, at the next link, on how to display macro code, and, also how to post your workbook:

    https://www.excelforum.com/forum-rul...rum-rules.html

+ 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 runs successfully but displays "Out of Memory" error at end
    By nobodyukno in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-22-2017, 10:37 AM
  2. [SOLVED] Macro gets "Run time error '7' out of memory" for ReDim Array
    By capson in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-10-2014, 12:52 PM
  3. Replies: 1
    Last Post: 07-06-2014, 04:20 PM
  4. [SOLVED] "not enough memory" error on workbook.save , but not .close(SaveChanges:=True)
    By sylvainsylvain in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-18-2013, 12:08 PM
  5. Every Error Message from VBA is coming back as "Out of Memory", while it is not!
    By TopXorGuy in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-30-2013, 10:57 PM
  6. "Not Enough memory to display" error when dropdown values in combo are selected
    By pabs1234 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-10-2012, 02:49 PM
  7. excell 2000 is giving an error "not enough memory"
    By 3Dbesh in forum Excel General
    Replies: 1
    Last Post: 02-08-2005, 08: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