Range("P1").Value = "Assigned To"
Range("p2").Select
Selection.FormulaArray = _
"=IFERROR(INDEX('Parked Consolidated'!C[-8],MATCH(1,([@[Company Code]]='Parked Consolidated'!C[-15])*([@Vendor]='Parked Consolidated'!C[-13])*([@[Document Number]]='Parked Consolidated'!C[-11])*([@[Posting Date]]='Parked Consolidated'!C[-9]),0)),""Not Assigned"")"
I get the error
Unable to set the FormulaArray property of the range Class.
Im not sure what this means, maybe an issue with the range in the table ? Im not sure how to fix it.
thanks in advanced.
David.
Range("p2").Select
Selection.FormulaArray = _
"=IFERROR(INDEX('Parked Consolidated'!C[-8],MATCH(1,([@[Company Code]]='Parked Consolidated'!C[-15])*([@Vendor]='Parked Consolidated'!C[-13])*([@[Document Number]]='Parked Consolidated'!C[-11])*([@[Posting Date]]='Parked Consolidated'!C[-9]),0)),""Not Assigned"")"
I get the error
Unable to set the FormulaArray property of the range Class.
Im not sure what this means, maybe an issue with the range in the table ? Im not sure how to fix it.
thanks in advanced.
David.