Excel VBA Array - copy down array from previous row and change few values

[cooolboy]

Could anyone have code to copy down the last row of a two dimensional array and amend few values in the newly created row?

 

[Gokulc]

cooolboy, Yes. I have the code to copy down the last row of a two dimensional array. Please let me know the values that need to be edited in the newly created row.

Sub Fill_down()


Range("A1").End(xlDown).Select
Selection.EntireRow.FillDown
End Sub