VBA Array Formula problem (list table refrencing)

[mahhdy]

Hi,
I want to update my array function with VBA, but it returns error.
Can anyone help?

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]))"

both resulting error.
Application -defined or object-defined error

Thanks Guys.

 

[pgc01]

Hi

Try:

Ds.Range("ac_wb2[Last RCVG]")(1).FormulaArray = "=IFERROR(LARGE(IF(tbl[Work Book]=Ac_WB2[@VWI],tbl[Rcvd Date]),1),"""")"