RTD Wrapper called for every cell in an array formula

D

davidw

I've written a VBA wrapper function that parses the string returned
from an RTD server, and then returns an array to Excel. This is the
documented solution from Microsoft (http://support.microsoft.com/kb/
q286258/)

This works. However, the VBA function is being invoked for every cell
selected. This is obviously unnecessary since the function returns
the data for all the cells. This is causing a significant performance
impact.

Does anyone know how this can be solved?

NB: This problem is avoided if the function containing the RTD call
returns a string. You can then call this function to place the
delimited data in a single cell. Then, from an array formula you
reference this cell (e.g. Evaluate(A6)). This works but is obviously
not as user friendly.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top