Hi,

I need to pass a matrix type data structure between Excel VBA and an
external DLL (XLL actually).

Because of the bug in Excel, where a call to
Application.Evaluate("MyXLLFunction()") will actually call my proc twice, I
want to be able to declare the external method in VBA and call it, without
using Evaluate.

This is easy enough with simple types, but I want to be able to return a
more complex data type back and forth, one similar to the Excel SDK's Multi
type, where you can return multiple rows of multiple columns.

Does anyone know the best way of doing this?

Thanks

Mike Davies