Trying to convert the following formuals into a VBA R1C1 format and I believe the part I'm not doing correct is.. ROWS(R2C1:R2500C1)
Its my first time really using an array formula in VBA so that could also be it. Thank You
This is what I did{=IFERROR(INDEX($A$2:$A$13, SMALL(IF(ISERROR(MATCH($A$2:$A$13, $C$2:$C$13, 0)), (ROW($A$2:$A$13)-MIN(ROW($A$2:$A$13))+1), ""), ROWS($E$1:E1))),"")}
Sub Test()
With Worksheets("Sheet3").Range("A2:A25000")
Selection.FormulaR1C1 = "IFERROR(INDEX(Sheet1!R2C1:R2500C1,SMALL(IF(ISERROR(MATCH(Sheet1!R2C1:R2500C1,Sheet2!R2C1:R2500C1, 0)), (ROW(Sheet1!R2C1:R2500C1)-MIN(ROW(Sheet1!R2C1:R2500C1))+1), """"), ROWS(R2C1:R2500C1))),"""")"
.Value = .Value
End With
End Sub