Macro starting from Row n.2

[TommasoP11]

Hi, please could you help me with this? I would like to commence this macro from Row. n.2 instead of Row. n.1:

Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Count > 1 Then Exit Sub
If Not Target.Column > 1 And Target.Column < 5 Then Exit Sub
If Not (Target.row > 1 And Target.row < Range("A" & Rows.Count).End(xlUp).row + 1) Then Exit Sub

Application.EnableEvents = False
Range("F" & Target.row & ":I" & Target.row).FormulaR1C1 = "=IFERROR(INDEX(R1C2:R1C4,1,MATCH(R1C,RC2:RC4,0)),"""")"
Range("F" & Target.row & ":I" & Target.row).Value = Range("F" & Target.row & ":I" & Target.row).Value
Application.EnableEvents = True

End Sub

Please which settings do I need to change in this Macro kindly provided to me to commence it from Row. n. 2? Many thanks for your help.

 

[Fluff]

Duplicate to: VBA macro: insert string value in the same row (number) after finding column header

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.