Ranges and memory

[mikeymay]

Does setting ranges e.g.

Set rngRange = range("DataRange")

use lots of memory?

I have a routine that loops through a process setting a number of ranges about 650 times and although the declared ranges in the code are getting re-used I am getting some 'Out of Memory' messages.

 

[iliace]

I'm estimating 450 bytes per range, give or take. Based on a rough experiment using an array of 100,000 range objects, assigned to distinct ranges of 700 consecutive cells each. Less or more cells does not seem to make a difference.

I'm guessing the problem lies elsewhere in the code. Something like recursion overhead might cause stack overflow, for example.