matrix and variable handling

---

@ID_10962613 wrote:

I would like to go through the same worksheet several times, changing "index" and the various parameters, and put the calculation results in the same Rez matrix, in the corresponding "index" column. Unfortunately the previously defined columns are set to zero.

---

Your worksheet does not show much of what you be trying to achieve.

Not sure what the input should be and  what you expect as a result.

Your function RR just returns the vector mx if the first function argument is 0, otherwise the return value is 0.

In case that the second function argument is not a vector, the function returns a 1x1 matrix containing it if opt=0.

I have no idea what you are trying to achieve, which worksheet and which calculations you would like to run several times and which 'index" (of what?) you want to change. And if you intend to use variables like "Option" and "Tab" you sure have to define them before you make use of them.

You will have to explain in more detail what you want to achieve. Provide examples and state what you expect as result.

Hi @ID_10962613,

I wanted to see if you got the help you needed.

If so, please mark the appropriate reply as the Accepted Solution. It will help other members who may have the same question.
Please note that industry experts also review the replies and may eventually accept one of them as solution on your behalf.
Of course, if you have more to share on your issue, please pursue the conversation. 

Thanks,
Anurag