Thread: VBA, Matrix
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default VBA, Matrix

Christian,

Just be aware that my example was a simple one, it assumes a single column,
or a single row.

It gets trickier, not hard just trickier, if you have n rows x m columns you
have to handle it accordingly, and you also need to cater for situations
where the UDF may create less values than the worksheet array.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Enrst-Christian Lehmann" wrote in message
...
Hello Bob,

Thank you very much! Your example runs perfectly on my computer! Now I
know what do do!

Regards,
Christian