| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Check for & remove Subtotal(s)
Currently I'm using a msgbox to ask users to manually remove subtotals before proceeding. If MsgBox("Pls ensure that subtotals, if any, are removed before proceeding", vbOKCancel) = vbCancel Then Exit Sub How can I include in my macro to first check if there is a subtotal(s) & to remove all? Or maybe stop the macro if there are subtotals found in the worksheet?  Any help is greatly appreciated! -- josnah ------------------------------------------------------------------------ josnah's Profile: http://www.excelforum.com/member.php...fo&userid=6334 View this thread: http://www.excelforum.com/showthread...hreadid=564663 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I remove ##### from subtotal and total rows | Excel Discussion (Misc queries) | |||
| Remove Entire subtotal row will be deleted | Excel Programming | |||
| Problem with Remove Subtotal in Macro | Excel Programming | |||
| Remove Subtotal In Macro Not Working | New Users to Excel | |||
| Remove subtotal where only one item | Excel Programming | |||
![josnah[_6_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
