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

SubTotals
 

try

Application.DisplayAlerts = False
Selection.RemoveSubtotal
Range("F8:AA321").Select

U¿ytkownik "MikeM" napisa³ w wiadomo¶ci
...
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

SubTotals
 

Excellent, Thanks!
--
MJM


"Jarek Kujawa" wrote:

try

Application.DisplayAlerts = False
Selection.RemoveSubtotal
Range("F8:AA321").Select

U¿ytkownik "MikeM" napisa³ w wiadomo¶ci
...
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

SubTotals
 

Just under the start of the Sub:
Application.DisplayAlerts = False

Just before the end of the Sub
Application.DisplayAlerts = True

Regards,
Ryan---

--
RyGuy


"MikeM" wrote:

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