Out of Memory when loading huge range into an array

[jscranton]

I am comparing the used range on every worksheet on two workbooks to find cells that were changed. Some of these worksheets have a massive range:

A$1:$CD$1048575

When I try to load this into an array, I get and Out of Memory error.

Is there anyway around this?

 

[Logit]

Dim X as Long

Set X = Range("A1:CD1048575")

????

 

[jscranton]

That's what I am doing and it is causing the out of memory error

 

[offthelip]

Have you tried loading the values into a variant array, this will be much smaller than a range array
Note NO "Set"

Dim inarr as variant
inarr=Range("a1:cd1048575")