Use array to speed up UDF calculations

Hi

I am quit new with working with VBA.

I have a lot of UDF in my sreadsheet and it is working very slow.

Therefore I am looking for a way to read inn all the input data in an array, calculate the functions
in vba and then print the results back to another spreadsheet. I guess this would be much faster,but
I have trouble understanding arrays....

This is the code I have come up with so far, but it is not working at all rather than printing some text back to the spreadsheet.

Please Login or Register  to view this content.

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #3 requires code tags. I have added them for you this time because you are a new member. Well, you're not new, but you only have 2 posts. --6StringJazzer




Thanks for any help.

Try (I trued to change as little, as possible - just enough to get desired result):

Please Login or Register  to view this content.

suggested reading: ways to pass arguments between fynctions/subroutines, scope of variables declaration, differences between subroutines and function - for instance there is no need to have Readmembers as function - shall be sub