Thursday, January 12, 2012

Add Blank Rows After Each Row in the Active Sheet

!....Excel VBA program to Add Blank Rows after Each Row in the Activesheet...!

Sub add_blankrow()

Application.ScreenUpdating = False
For i = 1 To Range("a1").End(xlDown).Row
ActiveCell.Offset(1, 0).Select
Rows(ActiveCell.Row).Insert
ActiveCell.Offset(1, 0).Select
Next

End Sub

No comments:

Post a Comment

Excel VBA to send email from excel with HTML table in a email body

'' Excel vba script to send email from outlook & email body in HTML table format. ''Write down email body in HTML tags...