How to use cell address instead of RC

  • As per the attached Workbook "VB MultipleCriteria-Ozgrid" I am trying to use the following formula:


    [f10].FormulaArray = "=SUM(SUMIFS(Qty,product,"" = "" & [f1], supplier,"" = ""&[f2:f4],delDate,"" >= ""&[f6])"


    instead of


    [f10].FormulaArray = "=SUM(SUMIFS(Qty,product,""=""&R[-9]C, supplier,""="" & R[-8]C:R[-6]C,delDate,"">="" & R[-5]C))"


    However, I get an error message
    Run-time error '1004':
    Unable to set the FormulaArray property of the Range class


    Also, I would like the "combo boxes" ListFillRange automatically updated when columns A,B & D is changed...the change should be reflected in Columns H,I & J alphabetically sorted (vba code for this is in "Module 1")
    Thanks