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