Subtotal Macro

[MattB]

I've developed a macro which amongst other things runs the subtotal wizard, this has worked fine with the first few files i've used it with until now, where i get the message 'Run-time error '1004': subtotal method of range class failed.'
Could anybody explain?

 

[Mark O'Brien]

Run the macro again, hit "Debug" and post the line of code that is highlighted in yellow. Until we see that line of code, the error could mean anything.

 

[MattB]

Selection.Subtotal GroupBy:=1, Function:=xlSum, TotalList:=Array(8), _
Replace:=True, PageBreaks:=False, SummaryBelowData:=True