LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #6   Report Post  
Posted to microsoft.public.excel.programming
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



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Getting a value out of a Matrix nsd Excel Discussion (Misc queries) 4 January 28th 10 05:15 PM
How can I transpose nXm matrix to mXn Matrix MIHir Excel Worksheet Functions 2 August 9th 08 11:44 AM
Matrix Help Gaffnr Excel Worksheet Functions 4 March 11th 08 09:08 AM
Help with Matrix Les Stout[_2_] Excel Programming 2 April 25th 06 11:14 AM
How to get the value in a matrix? Jeppe[_2_] Excel Programming 4 October 26th 04 02:27 PM


All times are GMT +1. The time now is 01:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"