I have a worksheet that calcultes rates interactively. I now want to run it
in a batch mode using another worksheet. This requires the new worksheet to
send an array to my existing worksheet wait for it to calculate it and then
copy the results back into another array from my existing workseet to my new
worksheet.

Can this done using macros? If so, what is the recommended solution?

Thank you in advance.
Kouros