Results 1 to 3 of 3

why cant i get identical sort from identical code

Threaded View

  1. #1
    Registered User
    Join Date
    12-29-2005
    Posts
    90

    why cant i get identical sort from identical code

    i have 2 identical section of code giving 2 different results, they are both supposed to sort a section of a sheet in order from oldest date 2 newest but one does it and the other doesnt, the only difference is the cell references, can anyone advise please

    Selection.AutoFilter Field:=3, Criteria1:="<>"
        Range("A3:D160").Select
        Selection.Sort Key1:=Range("C3"), Order1:=xlAscending, Header:=xlGuess, _
            OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
            DataOption1:=xlSortNormal
        Selection.AutoFilter Field:=3


    Selection.AutoFilter Field:=8, Criteria1:="<>"
        Range("F3:I160").Select
        Selection.Sort Key1:=Range("H3"), Order1:=xlAscending, Header:=xlGuess, _
            OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
            DataOption1:=xlSortNormal
        Selection.AutoFilter Field:=8
    Last edited by jimb0693; 10-07-2010 at 01:06 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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