That's what my version (2010 32bit) requires of memory:
Code:
22:36:21:0473 Call RangeCompare2: Don't Set to Nothing: WorkingSetSize 56.885.248 ( Reference )
22:36:21:0503 Start Timer: t = 0.000 sec: WorkingSetSize 57.458.688 ( 573.440 )
22:36:21:0513 arrCompare Loaded: t = 0.008 sec: WorkingSetSize 57.663.488 ( 778.240 )
22:36:21:0543 objDic Loaded: t = 0.032 sec: WorkingSetSize 58.724.352 ( 1.839.104 )
22:36:21:0543 arrData Loaded: t = 0.036 sec: WorkingSetSize 59.695.104 ( 2.809.856 )
22:36:21:0613 Output to Range2 Complete: t = 0.107 sec: WorkingSetSize 60.104.704 ( 3.219.456 )
22:36:21:0633 after End Sub: WorkingSetSize 58.912.768 ( 2.027.520 )
But it's freshly started, after several runs it will level on almost 80 million Bytes. The differences between Start and End look mostly the same with the set to nothing switch false, sometimes equals. With the set to nothing switch true I got the impression Start and End more frequently match, but maybe that's just imagination, actually I never counted.
06-18-2014, 07:52 PM
Similar Threads
replace data from variable with "sub and super script" from excel to word by vba
Windows 7 64bit 
Office 2010 32bit
Threaded Mode