How to convert a Huge matrix to a column?

[sushiant]

I Have a matrix and need to convert all cells in a single column and found a VBA to do that. The Problem is that VBA doesn't work in huge data like a 800x800 matrix, so I should divide that matrix to more possible tables.

Please Login or Register  to view this content.

[nankw83]

Hi sushiant,

Try below code ...

Please Login or Register  to view this content.

[sushiant]

Thanks a lot, it works great. You're a genius.

[nankw83]

Glad to help & thanks for the added Rep.