G
Gary Keramidas
i have an array formula that i'd like to evaluate in code and store it in a
variable instead of creating the array formula.
is it possible?
here is what the formula would look like if i wrote it to a cell:
range("A1").formulaarray = "=SUM(G" & iRow & ":I" & iRow &
")/TRANSPOSE($M$2:$M$4)*O" & iRow
i need to loop through some cells and total all of them, that's why i'd like to
store it in a variable.
variable instead of creating the array formula.
is it possible?
here is what the formula would look like if i wrote it to a cell:
range("A1").formulaarray = "=SUM(G" & iRow & ":I" & iRow &
")/TRANSPOSE($M$2:$M$4)*O" & iRow
i need to loop through some cells and total all of them, that's why i'd like to
store it in a variable.