PDA

View Full Version : How to save intermediate values in a VBA code execution?



volabos
02-22-2010, 12:59 AM
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
02-22-2010, 01:44 AM
I'm probably misunderstanding. Why would you need to copy/paste ea value. Plunk the array into a range the same size.

Mark