Results 1 to 4 of 4

Incompatibility? "Object doesnt support this property or method"

Threaded View

  1. #1
    Registered User
    Join Date
    11-13-2003
    Posts
    5

    Incompatibility? "Object doesnt support this property or method"

    Hi,

    I'm quite new to VB. Anyway, i have a worksheet macro created from officeXP, but doesnt run on 2003. I suspect it is this subroutine, as my macro shows this "Object doesnt support this property or method" when it run this subroutine. Can anyone help? thanks.
    Sub CreateSubtotal()
    '
    ' subtotal Macro
    '
    
    '
        Cells.Select
        ActiveWorkbook.Worksheets("Sheet1").Sort.SortFields.Clear
        ActiveWorkbook.Worksheets("Sheet1").Sort.SortFields.Add Key:=Range("J2:J1096" _
            ), SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:=xlSortNormal
        With ActiveWorkbook.Worksheets("Sheet1").Sort
            .SetRange Range("A1:J1096")
            .Header = xlYes
            .MatchCase = False
            .Orientation = xlTopToBottom
            .SortMethod = xlPinYin
            .Apply
        End With
        Selection.subtotal GroupBy:=10, Function:=xlSum, TotalList:=Array(7), _
            Replace:=True, PageBreaks:=False, SummaryBelowData:=True
    End Sub
    Last edited by royUK; 11-30-2008 at 11:04 AM.

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