Sometimes we need to put alternate empty rows in an excel. For this just copy below code and run macro.You are done.
Sub InsertAlternateRow()
Do While Not IsEmpty(ActiveCell)
ActiveCell.EntireRow.Insert
ActiveCell.Offset(2, 0).Select
Loop
End Sub
Sometimes we need to put alternate empty rows in an excel. For this just copy below code and run macro.You are done.
Sub InsertAlternateRow()
Do While Not IsEmpty(ActiveCell)
ActiveCell.EntireRow.Insert
ActiveCell.Offset(2, 0).Select
Loop
End Sub
No comments:
Post a Comment