Use VBA to get values from named range that contains an array formulaexpression
I've used an array formula (linest, as a test) to create an array
formula in an named range by typing the array formula into the Refers
to box on the Define Name pop-up window.
By entering the Index worksheet function in a worksheet cell, I can
access the values in the linest result 'array' but I can't figure out
how to access the values in VBA.
Surely someone has done this, but my best thinking and a lot of
internet searches haven't turned up an answer.
Thanks in advance, even if the answer turns out to be "You can't do
that!" :)
James
|