Help rewriting code to use less memory

I posted this problem a few days ago, here.

Now that I understand the problem a little better, I’m posting it again (hopefully a little clearer)

This line in the code causes a “not enough memory” error:

Please Login or Register  to view this content.

Is it possible to do this without using as much memory?
I’m stuck, so I appreciate all feedback!

This is the code with the values that result in a memory error. The full code is in the link above.

Please Login or Register  to view this content.

(I can't attach files for some reason)

Please Login or Register  to view this content.

DA needs to be in quotes otherwise it is considered to be an undefined variable.

Similarly,

Please Login or Register  to view this content.

DC needs to be in quotes

Again, in the following line, Temp is an undefined variable:

Please Login or Register  to view this content.

If Temp is a Named Range, it needs to be in quotes, thus:

Please Login or Register  to view this content.

Hi! Thanks for taking the time to reply.

My post is a mess. I've made a new thread and tried to clean it up.
http://www.excelforum.com/showthread...06#post4323406