Can someone tell me how you go about using the formula array in VBA? I have the following code:
Range("N10").FormulaArray = _ "=SUM((Miles>=R9C)*(Miles<R9C[1])*(Depth<=RC13)*(Depth>R[1]C13))"
I keep getting an error message stating that "Unable to apply Array Formula" and "Invalid name error"? Any suggestions on how to set the array formula in VBA
Thanks