Subtotal Macro

MattB · May 2nd, 2002, 09:04 AM

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 · May 2nd, 2002, 09:29 AM

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 · May 3rd, 2002, 01:27 AM

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

May 2nd, 2002, 09:29 AM	#2
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	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. __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 2nd, 2002, 09:04 AM	#1
MattB Board Regular Join Date: Mar 2002 Posts: 62	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?

May 3rd, 2002, 01:27 AM	#3
MattB Board Regular Join Date: Mar 2002 Posts: 62	Selection.Subtotal GroupBy:=1, Function:=xlSum, TotalList:=Array(8), _ Replace:=True, PageBreaks:=False, SummaryBelowData:=True