Hello:

In a simple macro that I created, I have the following:

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

Although this macro ran fine for days without error, all of a sudden, it is
giving me the "Subtotal method of Range class failed" error when I run it
today. (Must be a Monday...)

How do I fix this? It's Office 2007. Also, how do I save the fix? Every
time I try to make changes to the VBA Editor and save, it seems like it wants
to save a new doc. All I want to do is make the change (the fix), save the
change in the same macro file, and be done.

childofthe1980s