Results 1 to 8 of 8

Which part of my autofilter code doesn't work in 2003?

Threaded View

  1. #1
    Registered User
    Join Date
    08-19-2004
    Posts
    60

    Which part of my autofilter code doesn't work in 2003?

    Hi,

    I have a large amount of code which error's when running in Excel 2003. (it does not sort, whereas in 2007 it does).

    As i don't have Excel 2003 can someone tell me which part of my code does not run in Exccel 2003 please:

    Range("E5").Activate
        ActiveWorkbook.Worksheets("BranchList").Sort.SortFields.Clear
        ActiveWorkbook.Worksheets("BranchList").Sort.SortFields.Add Key:=Range("E5"), SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:=xlSortNormal
        With ActiveWorkbook.Worksheets("BranchList").Sort
            .SetRange Range("B6:AE65513")
            .Header = xlNo
            .MatchCase = False
            .Orientation = xlTopToBottom
            .SortMethod = xlPinYin
            .Apply
        End With
    Thanks
    Last edited by jamesryan; 03-19-2010 at 05:30 AM. Reason: solved!

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