Thread: SubTotals
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
MikeM MikeM is offline
external usenet poster
 
Posts: 64
Default SubTotals

I have a Macro that takes current subtotal in a range and removes them.
However, the Macro Stop and gives me a Message Box telling me that "Entire
SubTotal will be deleted" Choice of OK or Cancel. How can I have it not ask
me this and just automatically run remove the SubTotal?
The line simple reads as follows:

Selection.RemoveSubtotal
Range("F8:AA321").Select
--
MJM