+ Reply to Thread
Results 1 to 23 of 23

Sorting VBA Simplification

Hybrid View

  1. #1
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Sorting VBA Simplification

    Perhaps you could do it this way - you could play with the strings for the setups:

    Sub SUV(SgDV As String, SgSort As String)
    Range(SgDV).Sort Key1:=Range(SgSort), Order1:=xlAscending, Header:= _
    xlGuess, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
    DataOption1:=xlSortNormal:End Sub
    
    Call SUV("SgDV_TestGrp","SgSort_TestGrp")
    Call SUV("SgDV_Product","SgSort_Product")
    Call SUV("SgDV_Machine","SgSort_Machine")
    Call SUV("SgDV_SampleType","SgSort_SampleType")
    Last edited by xladept; 07-26-2013 at 03:31 PM. Reason: tidy up
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

+ 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] Formula Simplification
    By brharrii in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-24-2013, 10:46 AM
  2. Formula Simplification
    By nanocrazy in forum Excel General
    Replies: 2
    Last Post: 04-16-2010, 03:14 AM
  3. if statement Simplification
    By sk81681 in forum Excel General
    Replies: 16
    Last Post: 06-05-2009, 05:24 AM
  4. Simplification help
    By Mike Smith NC in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-12-2006, 01:35 PM
  5. [SOLVED] Simplification help
    By Mike Smith NC in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-12-2006, 11:05 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