In Excel 2010 existing code solutions using the RemoveSubtotal method may remove rows that were previously skipped. If developers want the rows to remain they should adjust the Range object that the RemoveSubtotal method is applied to so that it only includes the range which contains the SubTotals.
For Example the following code applies to all of the cells in a worksheet so any row containing a SUBTOTAL function will be removed.
291308 How to select cells/ranges by using Visual Basic procedures in Excel
Article ID: 2671038 - Last Review: Jan 30, 2012 - Revision: 1