View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default Run-time error '7'

You are trying to reserve an incredible amount of memory...

41,000 * 817 * 8(bytes per double) * 2(arrays) is over half a Gig of
memory... Memory aside you are not going to be happy with the performance of
arrays this big...
--
HTH...

Jim Thomlinson


"Soquete" wrote:

I have gotten a Run-time error '7':
Out of memory

message and I do not know why. My code is the Following:


Public m2() As Double
Public m1() As Double
Public Sub jk()
j = 41000
k = 817
ReDim m1(j, k)
ReDim m2(j, k)
End Sub