Forum Discussion

Copper Contributor

Mar 17, 2021

Dynamic Array Formula to include a cell formula in output

I have a basic dynamic array formula that uses various functions to calculate results. However one of the outputs needs to actually be a cell formula. Is this possible? I have shown below a simplifi...

Formulas and Functions

office 365

HansVogelaar

MVP

Mar 17, 2021

AndyD21

The elements of outputs are variants, you cannot set their Formula property.

And you must double quotes within a quoted string.

    Dim outputs(4)
    outputs(0) = 1
    outputs(1) = 2
    outputs(2) = "=IF(R8<>"""",((E8/1000)/T8)/(PI()*((LEFT(R8,3)/2000)^2)),0)"
    outputs(4) = 4
    PBD_Output.Value = outputs