Hi,
I keep getting an error when I use this code. The formula is matching the ActiveWorksheet cells to a file name Current.xls and pulling the answer/data from the Current.xls. The formula works fine by just doing the array in the excel file but when I try to automate it using VBA code I get an error message saying "Unable to set FormulaArray property of the Range class".
Here is the code:
Range ("C62").FormulaArray = "=INDEX('[Current .XLS]qry_BFFinal'!$A$2:$G$786,(MATCH(B2&B62&(B9+1),'[Current.XLS]qry_BFFinal'!$A$2:$A$786&'[Current.XLS]qry_BFFinal'!$C$2:$C$786&'[Current.XLS]qry_BFFinal'!$F$2:$F$786,0)),7)"
Bookmarks