• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Want to Insert Blank Line after Every Bold Line

rajubhayana

New Member
Hello ,

is there any easy way i need to add blank line in table, only unique is there is Bold cells , you can see there is no blank line till row 35, at present i am inserting row manually, hope you can suggest short cut,

Thanks

Rajeev
 

Attachments

  • Sample.xlsx
    39.2 KB · Views: 9
Try this VBA solution:

Code:
Option Explicit

Sub InsBlnk()
    Dim i As Long
    For i = 35 To 5 Step -1
        Application.ScreenUpdating = False
        If Range("B" & i).Font.Bold = True Then
            Range("B" & i + 1).EntireRow.Insert
        End If
    Next i
    Application.ScreenUpdating = True
    MsgBox "completed"
End Sub
 
Back
Top