Hi! please help me to figure out on how to put a text if only nothing follows to the word "TRIMFORM". below is the code that I used. Thanks in advance
Sub try()
Dim c As Range
For Each c In Range("D2:D429")
If c.Value Like "*TRIMFORM*" Then
c.Offset(1, 0).EntireRow.Insert
c.Offset(1, 0).Value = "Epoxy"
End If
Next c
End Sub
Sub try()
Dim c As Range
For Each c In Range("D2:D429")
If c.Value Like "*TRIMFORM*" Then
c.Offset(1, 0).EntireRow.Insert
c.Offset(1, 0).Value = "Epoxy"
End If
Next c
End Sub