Thread: Memory Problem
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
medialint medialint is offline
external usenet poster
 
Posts: 1
Default Memory Problem

Do you realize what you are doing? You are creating a multi-dimensional array 65000x200x1

Ignore the 1

What is 65,000 to the power of 200?

Right, a really big number.

This has nothing to do with loops. It has everything to do with memory allocation, and I don't care how much you spend on RAM SIMMs you're not going to get there.

Now tell us what you're really trying to accomplish because this is never going to work.