Run-time error '7'

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run-time error '7' 4
Runtime Error 1004 2
Runtime Error 1004 on Linest 7
Runtime Error 1004 on Linest in VBA 1
Need programming PROs help! Quiclk 1
VBA Function 0
MS Query 1
Array range error question 1

Back
Top