+ Reply to Thread
Results 1 to 2 of 2

Using custom sort with macros

Hybrid View

metalloidica Using custom sort with macros 10-21-2015, 10:42 AM
kadeo Re: Using custom sort with... 10-21-2015, 10:46 AM
  1. #1
    Registered User
    Join Date
    10-21-2015
    Location
    USA
    MS-Off Ver
    2013
    Posts
    1

    Question Using custom sort with macros

    So I'm trying to sort the asset classes in a portfolio using a macro:

    this is where the code stops running. Can someone help point out what I am doing wrong? Thanks!

    ActiveWorkbook.Worksheets("MSEXP1021092942").Sort.SortFields.Add Key := Range( _
            "C5:C27"), SortOn := xlSortOnValues, Order := xlAscending, CustomOrder := _
            "Cash,Money Market,US ETF Short-Term Bond,Short-Term Bond,Muni National Short,Intermediate-Term Bond,Intermediate Muni,Muni National Interm,Muni New Jersey Intermediate", DataOption := xlSortNor"& _
            "?
    Last edited by JBeaucaire; 10-25-2015 at 09:50 PM. Reason: Added missing CODE tags. Please read and follow the Forum Rules, link above in the menu bar. Thanks.

  2. #2
    Forum Contributor
    Join Date
    05-27-2014
    Location
    Belfast, Northern Ireland
    MS-Off Ver
    2007 & 2010
    Posts
    273

    Re: Using custom sort with macros

    It would be useful to see the rest of the code for context. We'll also need to know what error is generated when it stops as that may help diagnose the problem.
    Please click *Add Reputation if I've helped

+ 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. Challenged: ascending sort within custom sort
    By jhren in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-10-2013, 12:35 PM
  2. Macros and custom toolbars
    By JPCPA in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-01-2006, 01:59 AM
  3. Custom View Macros
    By jhovey in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-15-2006, 08:04 PM
  4. [SOLVED] Excel sort by Fill Color by custom list sort
    By Dash4Cash in forum Excel General
    Replies: 2
    Last Post: 07-29-2005, 06:05 PM
  5. Custom toolbar and macros
    By MD in forum Excel General
    Replies: 2
    Last Post: 05-10-2005, 01:06 PM
  6. Custom toolbars and macros
    By tonywig in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-10-2005, 07:48 AM
  7. Custom Menus and Macros
    By Terry in forum Excel General
    Replies: 0
    Last Post: 01-24-2005, 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