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.
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?![]()
Please Login or Register to view this content.
Thank you.
Bookmarks