Inserting Rows Through a Macro
Mike,
Try
Sub insertrows()
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
LR = Range("A" & Rows.Count).End(xlUp).Row
For i = LR To 2 Step -1
Range("A" & i & ":A" & (i + 1)).EntireRow.Insert
Next i
Application.ScreenUpdating = True
Application.Calculation = xlCalculationAutomatic
End Sub
Cecil
"Mike" wrote in message
...
I'm trying to create a macro in Excel 2002 where, I can
insert two rows between every number in column A:
Column A
1
2
3
4
5
6
7
8
9
Any ideas? Thanks in advance.
|