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 2010/05/06 17:59 UTC
Read the original article Hit count: 552

Filed under:
|

Hi,

I'm getting a Subtotal method of Range class failed Error when i try to run a macro. 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