Thank you Rana, for your kind support. Is it possible to accomplish this with a 
macro as I hane many rows to deal with?

Thanks 
Dave

________________________________

From: excel-macros@googlegroups.com 
To: excel-macros@googlegroups.com 
Sent: Sat Feb 26 01:45:23 2011
Subject: Re: $$Excel-Macros$$ SubTotal and Insert Req 


if u want to insert row after the subtotal line (i.e u are saying that you want 
to insert a blank row between the subtal
line, and the next group.) 

1-Right Click below the subtotal row, or on first row of below group 
2-Click on insert
3-Select "entire row"
4-Click ok



If u have any further question then mail me 


Rana Muhammad Sohail 
Pakistan 


On Thu, Feb 24, 2011 at 9:53 PM, Diamond Dave <dpehr...@walbro.com> wrote:


        Team, 1'm looking for support with the "SubTotal" function in excel
        2007 or 2010.  I'm looking to insert a blank row between the subtal
        line, and the next group.  Note:  the subtoal line exists in column A.
        
        Any Ideas?
        
        Thanks for your support
        
        --
        
----------------------------------------------------------------------------------
        Some important links for excel users:
        1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
        2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
        3. Excel tutorials at http://www.excel-macros.blogspot.com
        4. Learn VBA Macros at http://www.quickvba.blogspot.com
        5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
        
        To post to this group, send email to excel-macros@googlegroups.com
        
        <><><><><><><><><><><><><><><><><><><><><><>
        Like our page on facebook , Just follow below link
        http://www.facebook.com/discussexcel
        


-- 
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

-- 
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Reply via email to