TommasoP11
New Member
- Joined
- Jul 24, 2021
- Messages
- 6
- Office Version
- 365
- Platform
- Windows
Hi, please could you help me with this? I would like to commence this macro from Row. n.2 instead of Row. n.1:
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.
VBA Code:
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