Excel VBA (2007) Subtotal method of Range class failed

Posted by robihot on Super User See other posts from Super User or by robihot
Published on 2010-02-23T16:01:03Z Indexed on 2012/09/04 3:40 UTC
Read the original article Hit count: 253

Filed under:
|

I'm getting a Subtotal method of Range class failed Error when I try to run a macro in Excel 2007. Code works GREAT (no errors) when I run it using Excel 2003.

Here's a snippet...

'SubTotal Sheet
    Range("A1").Select
    Selection.Subtotal GroupBy:=1, Function:=xlSum, TotalList:=Array(3, 4, 5, 6, 7, _
        8, 9), Replace:=True, PageBreaks:=False, SummaryBelowData:=True

Any help would be appreciated.

© Super User or respective owner

Related posts about excel-2007

Related posts about vba