I have the following formula which is referencing another worksheet (All Sales) however the code keep looking for All Sales on the C drive.
cells[“B7”].SetSharedFormula("=IF(ISNA(VLOOKUP($A7,All Sales!$A$8:$Q$39,6,FALSE))=TRUE,0,VLOOKUP($A7,All Sales!$A$8:$Q$39,6,FALSE))", 128, 1);
How do you get it simply to look for All Sales in the current workbook?