Hi,
I want to update my array function with VBA, but it returns error.
Can anyone help?
both resulting error.
Application -defined or object-defined error
Thanks Guys.
I want to update my array function with VBA, but it returns error.
Can anyone help?
Code:
Ds.Range("ac_wb2[Last RCVG]").FormulaArray = "=IFERROR(LARGE(IF(tbl[Work Book]=Ac_WB2[@VWI],tbl[Rcvd Date]),1),"")"
or
Ds.Range("ac_wb2[Last RCVG]").FormulaArray ="=MAX(IF(tbl[Work Book]=[@VWI],tbl[Rcvd Date]))"
Application -defined or object-defined error
Thanks Guys.