Remove SubTotals Confirmation

[Mike H.]

when I do this:

Application.EnableEvents = False
Selection.RemoveSubtotal

I get a confirmation question dialog box:
Entire Subtotal Row will Be deleted. With OK or Cancel.

I am not sure why this particular sheet gives me that confirmation. I do
type text into some of the empty cells in the subtotals rows but I tested on
other sheets and don't get the confirmation message. Ideas?

 

[Jim Thomlinson]

try
application.displayalerts = false
Application.EnableEvents = False
Selection.RemoveSubtotal
application.displayalerts = true
Application.EnableEvents = true

 

[JLGWhiz]

What does the Help dialog say for that alert, or does it give that option?

 

[Mike H.]

There was no help for the message, but Jim's solution solved the problem.
Thanks...