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")

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!