VBA code to add blank row above specific text : Need help to add a blank row on a file above the word "Costumer". Found the below one but can't make it work on the specific worksheet on the workbook. thanks in advance 


     Dim c As Range
     For Each c In Range("A:A")
     If c.Value Like "Customer account" Then
     c.Offset(1, 0).EntireRow.Insert
     End If
     Next c