+ Reply to Thread
Results 1 to 2 of 2

Sorting on one column yields "not enough memory" error message

  1. #1
    Registered User
    Join Date
    07-06-2014
    Location
    Ellicott City, MD
    MS-Off Ver
    14.4.3
    Posts
    1

    Question Sorting on one column yields "not enough memory" error message

    I have a small spreadsheet on which I was able to sort yesterday, but today I received the error dialog "not enough memory" each time I try the sort. This cannot be a memory issue, as the spreadsheet is only about 340kb. Any advice on what I can do to remedy the problem?

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,601

    Re: Sorting on one column yields "not enough memory" error message

    Hi and welcome to the forum

    Maybe you have extra "junk" in the file now. Press End Home and see where the cursor ends up. If it is in the "middle of nowhere", start deleting rows and columns until you get back to where you know the last row and column intersect
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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. Sorting error message "missing column/row name"
    By sykesteacher in forum Excel General
    Replies: 1
    Last Post: 10-09-2013, 03:48 PM
  2. [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
  3. 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
  4. "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
  5. Error Message "Out of Memory" ??
    By walrasianxl in forum Excel General
    Replies: 1
    Last Post: 09-14-2010, 09:12 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