+ Reply to Thread
Results 1 to 5 of 5

Macro searching through inventory list..comes out of "Out of Memory" Debug

  1. #1
    Registered User
    Join Date
    08-01-2018
    Location
    Ann Arbor, MI
    MS-Off Ver
    2016
    Posts
    96

    Smile Macro searching through inventory list..comes out of "Out of Memory" Debug

    Hello!

    I have the following macro inside an order form that is to look up an Inventory Database and find each part number from the order form and add them to the inventory.

    This is the code:
    Please Login or Register  to view this content.
    It worked until today, where it came back with "Out of Memory" at the red line. It also has come back with "Object Required" for some of the runs where I have tried to update it.
    What is going wrong here? Why did this just start to happen? The green is an alternative method I have tried.

    Any suggestions are greatly appreciated.

    For backup information, I created the macro above with this post:
    https://www.excelforum.com/excel-pro...-workbook.html

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,029

    Re: Macro searching through inventory list..comes out of "Out of Memory" Debug

    Remove the word Select from this line
    Please Login or Register  to view this content.

  3. #3
    Forum Expert nigelog's Avatar
    Join Date
    12-14-2007
    Location
    Cork, Ireland
    MS-Off Ver
    Office 365 Windows 10
    Posts
    2,286

    Re: Macro searching through inventory list..comes out of "Out of Memory" Debug

    Try change
    Please Login or Register  to view this content.
    To

    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    08-01-2018
    Location
    Ann Arbor, MI
    MS-Off Ver
    2016
    Posts
    96

    Re: Macro searching through inventory list..comes out of "Out of Memory" Debug

    Those both worked!
    Thank you so much!

  5. #5
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,029

    Re: Macro searching through inventory list..comes out of "Out of Memory" Debug

    Glad we could help & thanks for the feedback

+ 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. After running the following macro excel shows "out of memory"
    By Md. Rain Man Raja in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-13-2017, 03:08 AM
  2. [SOLVED] Column X-Ref list - Sheet1 Col A "pages", Col B:FL "Req" to Sheet2 ColA "req", ColB "page"
    By excel-card-pulled in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 04-07-2017, 09:30 AM
  3. 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
  4. [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
  5. Excel 2010 (Run-time error '13' type mismatch) "Debug" and "Continue" Grayed out.
    By Jeronimo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-18-2012, 06:42 PM
  6. [SOLVED] Macro Array "Out of memory" any way around this?
    By Hyflex in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-30-2011, 07:02 AM
  7. Debug.Print "Test " vbCodeLineNumber & ": " & varName
    By TommySzalapski in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-02-2005, 01: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