+ Reply to Thread
Results 1 to 6 of 6

Problem in a custom sort code

  1. #1
    Registered User
    Join Date
    05-27-2021
    Location
    Strasbourg, France
    MS-Off Ver
    2010
    Posts
    28

    Question Problem in a custom sort code

    Hello the forum,

    I have a problem in the code of my workbook, code that I attach in the topic with the file. I would like to do a custom sorting in all the tabs in column E by means of a vba code. Because this file will be shared and it is not possible to export a personal sort...

    Thank you in advance for your help.


    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by Benten667; 06-25-2021 at 10:20 AM. Reason: File uptade

  2. #2
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,377

    Re: Problem in a custom sort code

    Hi Benten667,
    try this
    Please Login or Register  to view this content.
    Attached Files Attached Files

  3. #3
    Forum Expert
    Join Date
    08-17-2007
    Location
    Poland
    Posts
    2,532

    Re: Problem in a custom sort code

    Benten667
    The main problem with your code is that you are referencing a ListObject that is not there. Neither sheet contains a table (ListObject).
    Like nilem, but I add a custom list temporarily.
    Please Login or Register  to view this content.
    Artik

  4. #4
    Registered User
    Join Date
    05-27-2021
    Location
    Strasbourg, France
    MS-Off Ver
    2010
    Posts
    28

    Re: Problem in a custom sort code

    Hello, thank you both for your feedback which actually works in the excel case. I have simplified the basic file to make it easier to understand and access the code...

    But unfortunately I forgot to format the tables hence the presence of the "ListObject" function in my original code.

    Sorry I put the updated file in the topic above.

  5. #5
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,377

    Re: Problem in a custom sort code

    change
    Please Login or Register  to view this content.
    instead of
    Please Login or Register  to view this content.

  6. #6
    Registered User
    Join Date
    05-27-2021
    Location
    Strasbourg, France
    MS-Off Ver
    2010
    Posts
    28

    Re: Problem in a custom sort code

    ^^ Lazy when you hold us !
    I should have been able to see this!

    Anyway, thanks a lot Nilem! It's nice to have competent help

+ 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] vba code - Custom Sort on row1 - Left to Right
    By excel_googler in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-31-2021, 12:50 PM
  2. [SOLVED] Custom Sort VBA Problem
    By benjhardie in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-11-2019, 06:23 AM
  3. [SOLVED] custom sort simplify code
    By hopefulhart in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-11-2017, 09:17 PM
  4. Code For A Custom Sort Using A List On Another Sheet
    By rockyw in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-06-2016, 08:51 PM
  5. Custom List Sort - A struggling problem
    By rakesh_sss in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-29-2012, 02:50 AM
  6. Custom sort order problem
    By mfmcclellan in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-04-2012, 05:05 PM
  7. Add Custom Sort List to VBA code
    By Zyphon in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-12-2009, 09:44 AM

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