Adding into existing Code

[dbnfl]

Hello,

I have the below code and wan to add more of the sae code to match, copy and paste.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

'my formula on worksheet =INDEX('Wharf Schedules'!B:B,MATCH(Data!AO59&Data!AQ59,'Wharf Schedules'!C:C&'Wharf Schedules'!E:E,0))
'my formula on worksheet =INDEX('Wharf Schedules'!B:B,MATCH(Data!AO67&Data!AQ67,'Wharf Schedules'!C:C&'Wharf Schedules'!E:E,0))
Range("AL5").FormulaArray = "=IFERROR(INDEX('Wharf Schedules'!B:B,MATCH('Data'!AO5&AQ5,'Wharf Schedules'!C:C&'Wharf Schedules'!E:E,0)),"""")"
With Range("AL5:AL" & Cells(Rows.Count, "B").End(xlUp).Row)
Want to add this code in to existing code
'Range("AM5").FormulaArray = "=IFERROR(INDEX('Wharf Schedules'!G:G,MATCH('Data'!AO5&AQ5,'Wharf Schedules'!C:C&'Wharf Schedules'!E:E,0)),"""")"
'With Range("AL5:AL" & Cells(Rows.Count, "B").End(xlUp).Row)
.FillDown
.Value = .Value
End With

End Sub

Dale

 

[Peter_SSs]

Duplicate to https://www.mrexcel.com/forum/excel-questions/1106664-adding-more-code-existing-code.html

Please do not post the same question multiple times. Questions of a duplicate nature will be locked or deleted, per #12 of the Forum Rules and points 6 & 7 of the Forum Use Guidelines.

Any bumps, clarifications, or follow-ups should be posted to the linked thread.