try the following Macro. Follow the following steps.
1. press ALT+F11
2. INsert Menue m ja kar Module select karain.
3. Below code ko paste karain.
--------------------------------
Sub InsRows()
Dim LR As Long, i As Long, j As Integer
LR = Cells(Rows.Count, "
A").End(xlUp).Row
For i = LR To 2 Step -1
Rows(i).Insert
Next i
End Sub
---------------------------------------
Please original sheet par test karne se pehle aapni file k copy bana lain. Phir test karain.
Ye 10-15 second k time la ga aur har row k neeche new row add ho gae ge.
I assume k aap ka data column "A" se start hota ha. Agar nahee tu "A" ko apne matlooba column k name se change kar dain
Koi problem ho tu please reply.
regards.
Bookmarks