Converting a Named Range from a Formula to an Integer Array

Hi guys,

I currently have a named range that is a formula that produces a 300X40 array of integers. I would like to have this integer array be fixed after the initial formula generates the values, to improve speed.

Sub ConvertNamedRange()

    ActiveWorkbook.Names.Add Name:="CashFlowArr", RefersToR1C1:= _
        "={3,1,2;0,1,5;9,9,6}"
    ActiveWorkbook.Names("CashFlowArr").Comment = ""
    
End Sub

I used the marco recorder to generate the above code which is a simple 3x3 array. And I also understand how to add or edit a named range formula using vb, but what I can't figure out is how to enter the values from the output of a formula as an integer array. Any ideas?

Thank you.