Need a class that will allow me to populate a passed range (user defined) with values based on calculations done in a function.  The function is called from an excel cell.
Example cell formula is =DoCalc(Method as range, DataR1 as range, DataR2 as range, ResRange1 as range, ResRange2 as range) as double

The function calculates and returns a double to the calling cell.  That is no problem.  I would like to populate ResRange1 and ResRange2 too.

Can anybody help?

See the attachment. The formulacell is in yellow and I would like to populate the green cells.


JDS1

____________________________
jds1

____________________________
Attached:
Test.zip 12 KB (Downloads: 0)