As per the attached Workbook "VB MultipleCriteria-Ozgrid" I am using the RC formula in the vba code for cell "F10" on my "sheet2":
[F10].FormulaArray = "=SUM(SUMIFS(Qty,product,""=""&R[-9]C, supplier,""="" & R[-8]C:R[-6]C,delDate,"">="" & R[-5]C))"
However, once the code has run I cannot then click anywhere on my worksheet...is there a solution for this?
Thanks