I have the following:
cells[“A14”].SetSharedFormula("=IF(AND(AllSales3=“Location”, (AllSales1<>"")), VLOOKUP(AllSales1,AllSales2,1,FALSE),0)", 17, 1);
AllSalesN are Named ranges
I noticed that this formula is being applied from cell A1 rather from cell A14. How can I get the formula to be only applied from cell A14 downwards?