+ Reply to Thread
Results 1 to 5 of 5

error ascendig/descending

  1. #1
    Forum Contributor max_max's Avatar
    Join Date
    06-28-2013
    Location
    italy - venice
    MS-Off Ver
    Excel 2007
    Posts
    1,693

    error ascendig/descending

    Hello,
    I added 2 new macros to sort descending / ascending.
    Are included in the module3.
    They do not work error:
    error 1004
    error in the sort range for the class
    Where is the error?
    I attach the sample file
    Thank you,
    max_max
    ---------------------------------------------------------------------------
    Ciao,
    ho inserito 2 nuove macro per ordinare discendente / ascendente.
    Sono inserite nel modulo3.
    Non funzionano errore:
    errore 1004
    errore nel metodo sort per la classe range
    Dov'è l'errore?
    Allego il file di esempio.
    Grazie,
    max_max

    prova_2_new.xls

  2. #2
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: error ascendig/descending

    I have tested both codes and I did not get an error. I suspect the reason for getting an error is when you run the code, your cursor is on the wrong sheet. The code applies to active sheet. Your cursor should be on the active sheet before you run the code, or better is to fully reference the sheet name.

  3. #3
    Forum Contributor max_max's Avatar
    Join Date
    06-28-2013
    Location
    italy - venice
    MS-Off Ver
    Excel 2007
    Posts
    1,693

    Re: error ascendig/descending

    Hello AB33,
    a solution?
    max_max
    ------------
    Ciao AB33,
    una soluzione?
    max_max

  4. #4
    Forum Contributor max_max's Avatar
    Join Date
    06-28-2013
    Location
    italy - venice
    MS-Off Ver
    Excel 2007
    Posts
    1,693

    Re: error ascendig/descending

    If this macro:


    Please Login or Register  to view this content.
    is disabled there is no error.
    max_max
    --------------------------------------------------------------------------------------------------
    Se questa macro:


    Please Login or Register  to view this content.
    è disabilitata non c'è errore.
    max_max

  5. #5
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: error ascendig/descending

    The macro runs and I did not get any error. It may be that your events have been disabled or
    You are getting an error on
    Please Login or Register  to view this content.
    if your PC is size 64. I had to disable this line as my PC is 64, but that line works on 32 (Though I am not 100% sure)

+ 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. Using sort descending in VBA
    By eonizuka in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-05-2010, 06:05 PM
  2. Descending Counting
    By sparx in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-05-2007, 02:06 PM
  3. Descending Picture
    By 4derwent in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-07-2006, 04:13 PM
  4. sorting error:in descending order
    By ananga in forum Excel General
    Replies: 2
    Last Post: 06-30-2005, 12:05 PM
  5. descending subtotals
    By alexanderd in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-11-2005, 09: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