Thanks man it works!
Cheers
On Tue, Aug 23, 2011 at 10:45 AM, Rajan_Verma <rajanverma1...@gmail.com>wrote:
> *Try this :*
>
> * *
>
> *Sub InsertRow()*
>
> *For i = 13 To 22 Step 4*
>
> *Range("A" & i + 1).Select*
>
> *Range("A" & i + 1).EntireRow.Insert*
>
> *ActiveCell.Value = "Product breakdown"*
>
> *Next*
>
> *End Sub*
>
> * *
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Umar Abeer
> *Sent:* Tuesday, August 23, 2011 11:35 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Insert multiple rows using macros****
>
> ** **
>
> Hi everybody,****
>
> ** **
>
> I need to insert rows at specific intervals in multiple sheets & copy texts
> to those insertions. For example, after row 14 18 & 22, I want one row
> inserted & copy text "Product breakdown" to a14, a18, a22. ****
>
> ** **
>
> I have 50 sheets in my workbook with the same format, so I need it to loop
> through all sheets. ****
>
> ** **
>
> Thanks in advance.****
>
> ** **
>
> Regards,****
>
> Umar Abeer ****
>
> --
>
> ----------------------------------------------------------------------------------
> 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
