View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mike H. Mike H. is offline
external usenet poster
 
Posts: 471
Default Remove SubTotals Confirmation

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?