Hi, there
Has anyone got an example to pass a two dimentional array to a function and return a two dimentional array back. When calling this function, how to use the value in the returned two dimentional array?
Thanks.
Best regards,
Chunli
Hi, there
Has anyone got an example to pass a two dimentional array to a function and return a two dimentional array back. When calling this function, how to use the value in the returned two dimentional array?
Thanks.
Best regards,
Chunli
Last edited by SpringLily; 10-08-2010 at 05:31 AM.
You pass and return it the same way as a 1D array. The only difference is that when referring to values you use myarr(x, y) rather than just myarr(x)
Everyone who confuses correlation and causation ends up dead.
Thanks. R. The problem was a declaration confliction between the function and the main program calling it.
How to turn off and on the autocalculation in excel while my piece of code changes the value of a cell and this cell is not related to any cells.
Why do you need to turn off calculation if your cell does not affect any others?
This is a rather big Excel sheet with several different calculations. When I am debugging my code, I found at some instances when the code changs a cells value, different part of code in the same project will be run again. An implication for turning auto-calculation off?
Could be calculation, could be event procedures. Something like:
![]()
Please Login or Register to view this content.
Thanks! R![]()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks