How to save intermediate values in a VBA code execution?

[volabos]

Is there any way to save the intermediate values of a defined variable in VBA? There is one option "add watch" through which I can see the values however how to save it in some excel file? As here I am working with a big 2 dimensional array, it is totally impossible to copy-paste each value, therefore it would be good if I can save all the values in some excel file. How it possible?

[GTO]

I'm probably misunderstanding. Why would you need to copy/paste ea value. Plunk the array into a range the same size.

Mark