Hi,
I'm trying to write an array formula in VBA:
Range("B15").FormulaArray = "=INDEX('BASE PRODUCTION PROFILE'!$A$6:$A$800;MATCH(MIN(ABS('BASE PRODUCTION PROFILE'!$A$6:$A$800-A15));ABS('BASE PRODUCTION PROFILE'!$A$6:$A$800-A15);0))"
It's not working, showing me the error in the title.
Thank you very much!
Bookmarks