From: menke68@netscape.net   
      
   Hello,   
      
   I was wondering if anyone can help. I wrote a program in VBA. It does some   
   calculations with matrices (arrays) . These arrays are dynamic and are sized   
   according to a user defined input. The program works great when woriking   
   with a small number but as the number increases (estimate about a 50 x 50   
   array) the program will give a runtime error 7 message "Out of memory". 50 x   
   50 array does not seem like a lot and when I looked into the help there was   
   a mention of a 64k segment boundary. I'm not sure what this is, can anyone   
   help explain this ?   
      
   I was thinking this may be a limitation with running VBA on excel and wanted   
   to compile a stand alone executable program that will take the data placed   
   in excel cell and do all the number crunching in the program. I was hoping   
   someone could help me with the syntax to set a constant in a VB program and   
   set it equal to a cell or range in an excel spreadsheet (one that is open,   
   if this matters) and then write data to an excel range after calculations   
   have been done.   
      
      
   Thanks   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)