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: 255
excel-2007
|vba
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