+ Reply to Thread
Results 1 to 2 of 2

Run time error '438' after recording macros in 07 excel and attempting to run in 03

  1. #1
    Registered User
    Join Date
    05-02-2010
    Location
    USA
    MS-Off Ver
    Excel 03/07
    Posts
    17

    Run time error '438' after recording macros in 07 excel and attempting to run in 03

    Hi there,

    I recorded a handful of simple sorting macros in Excel 07 but when I try to run them in 03 they return "Run time error '438': object doesn't support this property or method". When I hit debug the bolded line is highlighted:

    Sub CCMMfinal()
    '
    ' CCMMfinal Macro
    '

    '
    Range("A2:H1701").Select
    ActiveWorkbook.Worksheets("Credit Card").Sort.SortFields.Clear
    ActiveWorkbook.Worksheets("Credit Card").Sort.SortFields.Add Key:=Range( _
    "A3:A626"), SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:= _
    xlSortNormal
    ActiveWorkbook.Worksheets("Credit Card").Sort.SortFields.Add Key:=Range( _
    "B3:B626"), SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:= _
    xlSortNormal
    With ActiveWorkbook.Worksheets("Credit Card").Sort
    .SetRange Range("A2:H626")
    .Header = xlYes
    .MatchCase = False
    .Orientation = xlTopToBottom
    .SortMethod = xlPinYin
    .Apply
    End With
    End Sub

    What am I to do? Thanks!

  2. #2
    Registered User
    Join Date
    05-02-2010
    Location
    USA
    MS-Off Ver
    Excel 03/07
    Posts
    17

    Re: Run time error '438' after recording macros in 07 excel and attempting to run in

    mods - I just realized that this probably shouldn't be in the "worksheet functions" subforum, please move if this seems more suitable in the general excel programming forum

    edit: cross listed here - http://www.mrexcel.com/forum/showthr...84#post2302084
    Last edited by pacer31; 05-05-2010 at 09:22 PM.

+ Reply to Thread

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