A correlation matrix via Excel VBA macro

[ebas1]

Hi, What would be the best way to create a correlation matrix via Excel VBA? I was going to just use the correlation function on the sheet but like I said, my columns and rows may change with time. Please see attached for my sample of my working.

Thank you in advance for your attention to this matter.

[ebas1]

Hi, What would be the best way to create a correlation matrix via Excel VBA? It is part of the large document.I manage to write every thing else on macro. but i can't do A correlation matrix via Excel VBA macro. Please help!!!

Thank you in advance for your attention to this matter.