;
> *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@g
Dear Umar,
Please use below code to insert row on specific area...
Sub InsertSpecificRows()
Dim InsQuan As Integer
On Error Resume Next
InsQuan = InputBox("Enter number of rows to insert", "Your Call")
If InsQuan <= 0 Then
MsgBox "Invalid number entered", vbCritical, "Stop!"
Exit Sub
End If
A
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
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
t
