Hi all, this is my first post and i think it is not an easy one as I cant even get started with it. I have a financial formula that i would like to run in vba. I have a correlation matrix, which is completed, then a code that sorts the relevant data for me to calculate this last step. I included the sheet with some dummy variables and limited data to be easy to understand. I know it is going to be a loop function but what i dont know is how to store a result in vba and recall it later...if someone could help me guide me thru this i would greatly appreciate it. tia