I have done a fair amount of higher level language programming but am somewhat new to VBA. I've run into some issues I can't figure out.
1. How can I pass multiple values back to a calling sub program? For instance, I have the Cholesky decomposition that will be called by a variety of programs. I can pass an array to the decomposition program but how do I get the decomposition back to the caller?
2. Accessing Excel functions is easy but how do I access the Excel sort routine?
Thanks for any assistance.
1. How can I pass multiple values back to a calling sub program? For instance, I have the Cholesky decomposition that will be called by a variety of programs. I can pass an array to the decomposition program but how do I get the decomposition back to the caller?
2. Accessing Excel functions is easy but how do I access the Excel sort routine?
Thanks for any assistance.